P pozzy Registered User. Local time Today, 09:35 Joined Oct 15, 2003 Messages 11 Sep 21, 2004 #1 Hi. I have a Links table that stores assets (AssetID) from a Asset table and connected to a client (ClientID) from a Client table. I wish to be able to display the current clients name on a asset details form
Hi. I have a Links table that stores assets (AssetID) from a Asset table and connected to a client (ClientID) from a Client table. I wish to be able to display the current clients name on a asset details form
P Pat Hartman Super Moderator Staff member Local time Yesterday, 19:35 Joined Feb 19, 2002 Messages 47,604 Sep 21, 2004 #2 Use a query that joins the two tables and selects the necessary columns from both as the RecordSoruce for the asset details form.
Use a query that joins the two tables and selects the necessary columns from both as the RecordSoruce for the asset details form.
P pozzy Registered User. Local time Today, 09:35 Joined Oct 15, 2003 Messages 11 Sep 21, 2004 #3 Thanks Pat. It does work, however I encountered a problem as there may be more than 1 user per asset
P pozzy Registered User. Local time Today, 09:35 Joined Oct 15, 2003 Messages 11 Sep 21, 2004 #4 I think I have found the solution. I have added a subform to the asset details form.
