If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Subform Problems
Good day,
I have a table with the field OrderID that is a primary key linked to other tables with one to many relationships. I generate a query based on these subforms and it does not display the information unless I go through each subfrom and press enter which makes a record. Basically I donot want to have the user to do this all the time if they feel like skippping a subform. Any Idea on how to take care of this so my query works regardless. I have set all me defaults to Zero on the subforms hoping this would do the trick however it doesnt. Hope this makes sense, any help would be appreciated. Thanks in advance |
#2
|
|||
|
|||
Subform Problems
Don't you mean "sub-forms based on a query"?
Have you set the Link Child Fields and Link Master Fields for each of the sub-forms on the main form? what do you mean by "going through" each suform, and how does a user "skip" one? John K wrote: Good day, I have a table with the field OrderID that is a primary key linked to other tables with one to many relationships. I generate a query based on these subforms and it does not display the information unless I go through each subfrom and press enter which makes a record. Basically I donot want to have the user to do this all the time if they feel like skippping a subform. Any Idea on how to take care of this so my query works regardless. I have set all me defaults to Zero on the subforms hoping this would do the trick however it doesnt. Hope this makes sense, any help would be appreciated. Thanks in advance |
#3
|
|||
|
|||
Subform Problems
Hi, Thanks for taking the time to try and help me out.
Okay I have a main table and other tabels that link to the main table with a one to many relationship. each table that links to the main table is a subform. I have 3 in the main form. My tables a Main - **Main table Press - ** Subform PrePress-** Subform Shipping-** Subform My Query takes the information and sums the totals for each record. This is so I can generate a report based on the information entered. The user can skip a subform for example Press if the operation is not required. The query does not display the records unless each subform has information. If I go through each subform and press the enter key which inturn creates a record in the subform and then displays in the query which inturn produces the information in my report. It is like the PressID (Number) which is linked to the Main table -MainID(AutoNumber)(Primary Key) linked by a one to many relationship. MasterField is MainID and the ChildField is PressID. The pressID does not produce the AutoNumber in it unless I hit enter which creates a record in the Press ID. Hope this makes sense Hope this makes sense. "J. Goddard" wrote: Don't you mean "sub-forms based on a query"? Have you set the Link Child Fields and Link Master Fields for each of the sub-forms on the main form? what do you mean by "going through" each suform, and how does a user "skip" one? John K wrote: Good day, I have a table with the field OrderID that is a primary key linked to other tables with one to many relationships. I generate a query based on these subforms and it does not display the information unless I go through each subfrom and press enter which makes a record. Basically I donot want to have the user to do this all the time if they feel like skippping a subform. Any Idea on how to take care of this so my query works regardless. I have set all me defaults to Zero on the subforms hoping this would do the trick however it doesnt. Hope this makes sense, any help would be appreciated. Thanks in advance |
#4
|
|||
|
|||
Subform Problems
For Example: Try This.
Create a Table Called MAIN Fields/Structure a MainID - AutoNumber (Set as Primary Key) Date - Date/Time Sales Name - Text Create another Table Called PressID Fields /Structure a PressID - Number Description - Text TotalCost - Currency Create a relationship between the two MainID to PressID one to many checking off all three boxes. Then create a form with the maintable information and the Press table information as the subform through the wizard. Only fill in the MainTable information in the form. You will see the PressID return 1 which is correct (Same as main table) Generate a query based on this infomation and you will see that nothing shows up unless you press enter in the PressSubform creating a record. or put in information. "K" wrote: Hi, Thanks for taking the time to try and help me out. Okay I have a main table and other tabels that link to the main table with a one to many relationship. each table that links to the main table is a subform. I have 3 in the main form. My tables a Main - **Main table Press - ** Subform PrePress-** Subform Shipping-** Subform My Query takes the information and sums the totals for each record. This is so I can generate a report based on the information entered. The user can skip a subform for example Press if the operation is not required. The query does not display the records unless each subform has information. If I go through each subform and press the enter key which inturn creates a record in the subform and then displays in the query which inturn produces the information in my report. It is like the PressID (Number) which is linked to the Main table -MainID(AutoNumber)(Primary Key) linked by a one to many relationship. MasterField is MainID and the ChildField is PressID. The pressID does not produce the AutoNumber in it unless I hit enter which creates a record in the Press ID. Hope this makes sense Hope this makes sense. "J. Goddard" wrote: Don't you mean "sub-forms based on a query"? Have you set the Link Child Fields and Link Master Fields for each of the sub-forms on the main form? what do you mean by "going through" each suform, and how does a user "skip" one? John K wrote: Good day, I have a table with the field OrderID that is a primary key linked to other tables with one to many relationships. I generate a query based on these subforms and it does not display the information unless I go through each subfrom and press enter which makes a record. Basically I donot want to have the user to do this all the time if they feel like skippping a subform. Any Idea on how to take care of this so my query works regardless. I have set all me defaults to Zero on the subforms hoping this would do the trick however it doesnt. Hope this makes sense, any help would be appreciated. Thanks in advance |
Thread Tools | |
Display Modes | |
|
|