I have my database structure layed out, but I am having trouble making a form for it.
If I use the form wizard to select fields from multiple, related tables it places them fine. And all the fields from all the tables show up in the field list box. But I need to know how to do this without the wizard.
The only way I can find to access fields from other tables is to build a subform, but I don't want to do that.
So my question is how do I place a field that is not from the table that the form is initially based on, but is related to that table without using a subform? The wizard does it fine, so how can I do it?
If I use the form wizard to select fields from multiple, related tables it places them fine. And all the fields from all the tables show up in the field list box. But I need to know how to do this without the wizard.
The only way I can find to access fields from other tables is to build a subform, but I don't want to do that.
So my question is how do I place a field that is not from the table that the form is initially based on, but is related to that table without using a subform? The wizard does it fine, so how can I do it?