Is it possible to a make a form in Microsoft Access where a you can create entries in 2 tables in the same page?
Imagine there is a table with 3 fields:
- ObjectId
- ObjectName
- TypeId
where TypeId
is the PK of another table which has the following fields:
- TypeId
- TypeName
I want to show in my form 2 editable text fields
- ObjectName
- TypeName
I want the user to be able to add both Objects and Types but, the way I am implementing it, it can only
- add a
Type
entry when adding aObject
- edit the associated
Type
when editing aObject
But I want to also be able to
- select a exisiting
Type
when adding aObject
- add a
Type
when editing aObject
In the same form