Access Form on Qry vs on Tbl

[zollo9999]

Hi

Sorry if this question is rather basic but I'm not sure if there is a clear answer.

Also my question is of a generic nature. ie I'm trying to findout if there is a general rule about this.

As usual, I am building a form based on data from two separate tables.

Is it good practice to always design a form based on a query joining the two forms?

My options are:

1. as above, base the form on a query that joins the two tables (then if i need to expand the form, I can add the fields to the query first, then add them to the form),
or

2. base the form on the main table, and use a bound control in the other table to push the data into the control using a procedure in an after update (or other) event,
or

3. base the form on the main table, and use an unbound control to pull the data into the control from the second table using a formulae in the control source. (I think this option aids lookup only, I won't be able to edit or save changes to data in the second table).

Thanks in advance.
Any feed back would be appreciated.
Paul

alias Zollo9999

 

[Gazer44]

It all depends on what you want the database to do but I'd say option 1 is the best and easiest.
Make sure your tables are connected OK (i.e. 1 to many, etc.) and use a query. This will enable you to manipulate the data it displays.