Input form for related one-to-one tables?

[jgarcia@nmvinc.]

Hello all,
I'm trying to something fairly basic I think... but not sure on the process.

I have two tables...

'New_Category_Dataport' and 'Category_details'

... the two tables are linked by a common field called 'Category_Dataport_ID'... (it is the primary key in both tables and a text field in both tables).....

I am trying to build a basic form where I can add a record with information in both tables... and entering the 'Category_Dataport_ID' that links the two tables...

Would greatly appreciate it if someone could help at all...

Thanks,
John

 

[edtab]

'Category_Dataport_ID' should be a foreign key in the
Category_Details table, not a primary key. Category_Details
should have its own separate primary key.

You can create a main form with a sub-form whereby the
'New_Category_Dataport' becomes the recordsource of your
main form and 'Category_details' the recordsource of your subform.

The subform should have a parent/child relationship with the main
form using 'Category_Dataport_ID' as the field to link them together.

 

[RuralGuy]

If in fact it is a 1:1 relationship, then it should probably be all in one table.

 

[jgarcia@nmvinc.]

Thanks for the input...

The reason they are two tables..(sorry, should have mentioned it before...) is that one table of data comes from another data source ....... so the additional info we add to the database is put into another table....

And now am just trying to build the form to manually add records to both tables at once

 

[RuralGuy]

Have you tried linking the two tables together with your existing field in the Relationship window and then creating a query with both tables in it?