Add new records that have info linked to other tables

[julie67]

I have a "Names" table and I have a "Property Information" table. I have a third table "Property Names Association" table. The Names table has information on people. The property information table has information on specific properties. These are not in the same table since multiple people can own a single property and a person can own shares in multiple properties. The "Properties Names Assocation" table creates new unique records to demonstrate which people own which properties.

I need to build a form that gives the user the option to do all of the following:

Add names to the names table
Add properties to the property information table
Associate names to properties

I can build forms to do each task, however I would like one form that gives the user the option to do all three.

Any suggestions?

thanks,
Julie

 

[hkaing79]

Personally, I would create three forms to reduce the clutter. However, to use one form, look into tabs.

The other option is to lay out all the data you need using an unbound form and use SQL statements to add/delete/update records.