create form with fields from different tables

  • Thread starter Thread starter Smoki
  • Start date Start date
S

Smoki

Hi,
I want to create form with fields from several tables, but I don't want to
create form with subform, I want to create simple form. How to do that?
I'm using 4 tables, and 3 of them are in a relationship with the fourth,
one-to-many relationship.

I done it few months ago, but I can't remember how. It give me only option
form with subform now.
 
experiment with a query that merges those fields together

in this situation however; depending on the relationships between the cross
referencing fields - one may not be able to update fields.... try it and see
 
I know that I can't update fields, because using form with subform, but I
only want to see those fields, and then to print report.
And, I can't remember how. I have query, but it still doesn't work.
 
Well, you told me to try with query. I have query with all those fields which
I have on my form. I created form through form wizard, where I choose fields
from different tables, and next step is to choose form with subform or linked
form. But I don't want none of them. I want simple form with fields. How to
create simple form?

Smoki
 
Again me!
I solve problem. I didn't use query, and problem was with choosing table. In
those step, when I have to choose how to show my data, and then change by
some other table (not default), it created simple form. Finally...
 
Back
Top