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
|
|||
|
|||
Record Relations
hi is there a way of say having a list of records, and having a text box on
the list noting how many records are related to that one; eg a list of products product name; product number; qty but then has a text box noting the number of materials related to the product (if each material has its own record) |
#2
|
|||
|
|||
Record Relations
What you want to do can be done. However, you would need to do this in a
form, not in a table. You would use the DCount function to get the counts from the associated tables for any current product. ----- HTH Mr. B http://www.askdoctoraccess.com/ Doctor Access Downloads Page: http://www.askdoctoraccess.com/DownloadPage.htm "VainDM" wrote: hi is there a way of say having a list of records, and having a text box on the list noting how many records are related to that one; eg a list of products product name; product number; qty but then has a text box noting the number of materials related to the product (if each material has its own record) |
#3
|
|||
|
|||
Record Relations
It sounds like you need tables that look like:
TblProduct ProductID ProductName ProductNumber Qty TblMaterial MaterialID Material TblProductMaterial ProductMaterialID ProductID MaterialID For each product, TblProductMaterial would record each material related to the product. A totals query based on TblProductMaterial with an appropriate criteria for ProductID could then give you the total material items for any selected product. Steve "VainDM" wrote in message ... hi is there a way of say having a list of records, and having a text box on the list noting how many records are related to that one; eg a list of products product name; product number; qty but then has a text box noting the number of materials related to the product (if each material has its own record) |
Thread Tools | |
Display Modes | |
|
|