Howdy, Stranger!

It looks like you're new here. If you want to get involved, click one of these buttons!


Database tables and problems linking them


I am trying to make a program that keeps track of varying information about different people. My db is set up with 3 tables:

1) Owner; field name: Owner*.
2) DNRNumber; field names: DNR Number*, Owner, Farmer, Field Number, Acres.
3) Site; field names: Record Number* (autonumber), Site number, Field number, Crop, Owner, Date.

*=Primary Key

First, the owner is created, from there, the DNR Number(s) assigned, and finally the Site number(s).

On the first form, I have been able to add names to the database, and to cycle through them. When I try to add information on the DNR Number form, nothing gets added. Here is what I have been trying to do: datOwner pulls the owner from the database; RecordSource: Owner. The rest of the info I have linked to datDNR, RecordSource: DNRNumber.

As you probably know, this doesn't work. Why?

I get similar results when I link to an ADODC. Are the tables set up incorrectly? What am I doing wrong?

-Using VB 6 Pro/XP Pro
-Never programmed before this

Any help will be greately appreciated!
Thank you so much

Sign In or Register to comment.