help with Calculation or script?

[Dani R]

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?

[mr_vodka]

What is the purpose of this history table? We can probably offer better advice if we knew the purpose here.

[Dani R]

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 .

[mr_vodka]

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