field list from more than one table?

[darksniper]

I would like to work on the form with more than one table without having to use a subform. I remember there was an option to have field list of more than one table. Because I need to add a field to a form that has 'one to many' relationship between two tables so that I dont want to modify existing table and redoing all of my forms.

 

[ColinEssex]

Forms should not be bound directly to a table, they should be bound via a query. Then you can have multi tables.

Col

 

[darksniper]

ok, then I have a question.

I have a form currently to register students. Which puts the data directly into the table. But due to sertain circumferences I need to have an option to choose if the student is a guest or not. I do not want to add an extra field to that table to I have created another table that contains student id and type (guest or not). That table will have most of my queries based on it. But I want to be able to specify in the form that he is a student or not. If you say I should not bind form to a table but rather to a query, then how should I do it?

 

[ColinEssex]

Make the recordsource the query and not the table.

Col

 

[Rich]

I do not want to add an extra field to that table

Why not ?