And yet another access query... sorry!

[Spardan]

OK... I have 3 tables that could concievably be joined together... the relationship between each row is a one to one. However, for data retrieval purposes it makes more sense to keep the data in separarate tables.

I have an autonumber being generated in one table, and thought I could get that to be automatically copied over to the other two to link them, and I'm sure that it's possible. I'm just dumb and have forgotten or something lame like that... any pointers, once again, would be greatly appreciated... :t

[DocEvi1]

so you have 3 tables whose primary keys are an autonumber, you want to put this ID into the other tables as a foreign key...

You can't do it "automatically" but you can set up tables to contain the keys so that data can be retrieved in one fell swoop.

[Spardan]

Thanks DocEvil... I'm trying to automate as much of this as possible because th epeople who're going to be using it are prone to data entry errors... I found a few VB scripts, but I'm not being paid enough for that (I hate VB anyway - flame ahoy!) and it turns out that, after a discussion there's no real need to separate the data - I can do all that with some linked SQL queries later...

thanks for your help though :D