Multiple Tables in one form

[SOLTEC]

I have a very large application that contains multiple tables for each form. I am trying to figure out how to display one form but binding that form to multiple tables? Example:

First Call form needs to link to:
Personal Information Table
Person Who Called Table
Place of Death Table
Location of the Body Table
Physician Table and finally
Permissions Table

Each table has multiple rows and columns to be included. I have tried creating an unbound form and dragging and dropping the subform and it's a mess. Any help would be greatly appreciated, and thank you in advance for the support and your time.

 

[Micron]

There are two approaches you could take, depending on what you have and what you need to do. One is to have the primary (e.g. master) records displayed on a main form and the related records below in one or more subforms. This is likely to be the most flexible in terms of controlling which subsets can be edited. The other is to create a query that involves all the tables and base your single form on that. However, sometimes this results in a query that is not editable, and if that is a requirement of your form, it will not work as desired.

Your tables design is the foundation and if you have not done that correctly it won't support much in the way of data entry or retrieval. Simply showing the names of your tables does little to indicate where you are with that.

Forgot to mention that in my book, forms and reports are based on queries and almost never just tables which means that I don't build forms first and then find out they don't work.