Why can't I type in all the fields?

[Naia]

I have attached an over-simplified version of what I have been working on. I would like to create a single form with fields from two tables. I do not want to use a subform.

So far I have been able to create and view my desired form, but I cannot type in all the fields.

Any ideas or suggestions?

Thanks

 

[boblarson]

Okay, I took a look and you have several issues going.

1. You should not use special characters in your object/field names. I renamed your WorkOrder# to WorkOrderNum

2. You didn't have any primary keys set up. Plus your relationships were a bit off, due to that. I set it up the way it should be.

3. You were linking a one to many tables and trying with one form (won't work you must either use two separate forms or subforms. I created a sample form for you with a subform to show how easy it is to do and use.

I have attached your db with my changes. Take a look at the tables, their fields, the relationships and the new forms.

 

[Naia]

Thank you, However

Thank you for the help and the pointers on relationship links, however, the form you created still uses a subform. I have a database full of forms that do not use subforms, I would attach one to show you except I can't compress it enough to upload. However, if I have not explaining myself clearly, I have attached a help file that has a graphic describing what I would like to create. #1 and #2 safe to two different tables but do not use a subform. Do you know how to do this?

Thanks

 

[CraigDolphin]

As far as I can tell, the graphic shows a Form (single form view bound to the customers table)with a subform (single form view bound to the Orders table) that contains a sub-subform (datasheet view bound to the OrderDetails table with a control that looks up the Product name from the Product table using the ProductID in the OrderDetails table).

The only difference is they've formatted the subform so that they're not 'sunken' and have no visible borders. Those are easy changes to make if you look in the format tab of the properties of the subform controls (the container in which the subform itself is shown) on your form.

Listen to Bob Larson.