Trying to create a form by relating to multi-tables

[klee]

Hi, I have created a form which consisted a subform. Actually, this form needs to related to 4 tables, but everytime, when I click on the add record button on the main form, the subform has disappeared. I figured out it is a problem about the table. I tried to create this form with 3 tables, and it worked, however it doesn't work for 4, is there any way i can solve this problem. I need to get it fix by tuesday. Your comments are highly appreciated

 

[jwindon]

The subforms will only show if there is data in them that DOES link them to the parent form.

I.E.

If there are no ORDERS for CUSTOMER 12, the the subform ORDERS of CUSTOMER 12 will not show.

 

[klee]

so does it mean that I need to enter the order data into the table, then the subform will display the data, or else it is always blank?

 

[klee]

Thanks for the solution,but I guess I did not state the question clearly.
I'm creating a database that allows the management to assign tasks to the programmers and users.
This is the tables that I have

Request Assignment
~Request# (Primary) ~Request(com.key)
~UserID (Foreign) ~Project#(Comp.key )
~RequestDate ~Beginningdate
~Purpose ~EndingDate

Project Task
~Project#(primary) ~Project#(Com)
~ProjectName ~ProgrammerID(Com)
~DescriptionofProject ~Task#(Com)
~Task Description

Programmer
~ProgrammerID
~Name

These are the five tables that relate to each other. Assignment and Task are the associative entities. Relationship between Request and Assignment is 1 to many; Project to Assignment is 1 to many; Project to Task is 1 to many and Task to Programmer is Many to 1.

My form is that allow the management to assign project to the programmer. It means that whenever user click on the Add Manament info button, there should be a new subform that allow the management to fill in particulars.

I hope this information is helpful