sigh...my first post and the whole thing gets lost because it asks for my username and password again....i'll try to rewrite it....
I'm making an Access database for a construction company. I have our products split into 3 categores -- Construction, Services, and Replacement Parts, each with its own table, because they each have different types of information. For example, the Construction table has address information that can differ from the address of the customer, along with details of the object being constructed. I use a query to combine the information from the 3 tables into one query, notably by abbreviating and concatenating the unique fields into a common "description" field. This item query can then be used as an overview list of the items in the order in Access or for a report similar to a bill.
When viewing the order in Access, I want the name and address of the customer at the top, and the item query list at the bottom. I want to be able to click on each item, or on a button next to each item, to pull up a pop-up window that contains the full details for the item from that item's table (before the item query abbreviated everything together), and be able to modify the item details and have arrow buttons to move through each item in the order. How should I go about doing this? I'm thinking of making the list at the bottom of the order form either a subform or a subreport with buttons added next to each each entry. Would it work both ways? I'm not sure how to tell the pop-up window which entry I clicked on or next to.
I'm making an Access database for a construction company. I have our products split into 3 categores -- Construction, Services, and Replacement Parts, each with its own table, because they each have different types of information. For example, the Construction table has address information that can differ from the address of the customer, along with details of the object being constructed. I use a query to combine the information from the 3 tables into one query, notably by abbreviating and concatenating the unique fields into a common "description" field. This item query can then be used as an overview list of the items in the order in Access or for a report similar to a bill.
When viewing the order in Access, I want the name and address of the customer at the top, and the item query list at the bottom. I want to be able to click on each item, or on a button next to each item, to pull up a pop-up window that contains the full details for the item from that item's table (before the item query abbreviated everything together), and be able to modify the item details and have arrow buttons to move through each item in the order. How should I go about doing this? I'm thinking of making the list at the bottom of the order form either a subform or a subreport with buttons added next to each each entry. Would it work both ways? I'm not sure how to tell the pop-up window which entry I clicked on or next to.