Microsoft Access help

[RynMan]

Hey guys

This question has been bugging me for quite some time, and I never found out the answer.

If you have say, 3 tables, all linked via an ID number. How is the best way to set up a form/forms to enter data?

I tried putting all of the variables from all 3 tables on one form, but I'm sure I'm going to have issues because there will be 3 ID fields. Do you place them on 3 separate pages? This doesn't seem practical.

How would you do it?

[Amazinz]

There is no problem (normally) with having multiple ID fields on a single form. Another option is to use a query to merge all the relevant information from the three tables into a single view. Then you can bind on the ID field of the query.

[RynMan]

There is no problem (normally) with having multiple ID fields on a single form. Another option is to use a query to merge all the relevant information from the three tables into a single view. Then you can bind on the ID field of the query.

Dammit! I posted this in GT because I'm sick of having to bother you with stupid simple database questions!! I do appreciate the help though. Thanks A.

Reexamining my data, it appears that I should probably just put all of my data in one table. There won't be any redundancy, which means I don't really require more than one table, right?

[Amazinz]

It's no problem. I'm not hunting you down. I just spotted the thread this morning sit here lonely.

Yeah if there's no redundancy and every record for the most part use every field than it's far more efficient to have a single table.

[RynMan]

It's no problem. I'm not hunting you down. I just spotted the thread this morning sit here lonely.

Yeah if there's no redundancy and every record for the most part use every field than it's far more efficient to have a single table.

Could have saved myself many hours of slamming my head against a wall. Thanks again hehe.