April 8, 200916 yr i have 3 tables. table 1 is my Contacts, table 2 is my Storeroom, table 3 is my history. in history table i have a filed what will have or Contacts or Storeroom number. what i need help with is in history table i have a filed with the name os the Contacts or Storeroom name "C_S_name" how can i get the name from Contacts if it is from Contacts the line of history, orhow can i get the name from Storeroom if it is a Storeroom table?
April 8, 200916 yr What is the purpose of this history table? We can probably offer better advice if we knew the purpose here.
April 9, 200916 yr Author i rent out sound items. i have 2 storeroom and 50 customers . i what to keep a track of all the history of the items that when u check it in i will select to the storeroom it came back to .
April 9, 200916 yr So then why not just have it so that your rental history has fields as such: Rental_Date, ItemID, Customer_ID, StoreRoom_Out, StoreRoom_In
Create an account or sign in to comment