Two tables to one record?
Posted: 2015-12-11 18:03
I do not know if this can be done. But will not hurt to ask.
I am starting a new project I hope. I have three tables. One is company then expense and the last is trip report. What I need to do or see is. If you make up a new record on Company. is there a way to have the expense table and trip report to be new for each record in company? You might get a better idea if you look at what I am trying to do at: http://tandy-services.com/tripsheet/index.php
You will see the 3 tables. If you click on Company you will see there are 2 trips. When you click on Expenses there is one for the first record in Company. Then in trip report all the records in there only belong to the first record in Company.
Now in the second record of company, How can I get the expenses and trip report to reset to the second record in Company? If that is even possible?
Thanks for any help
James Tandy
I am starting a new project I hope. I have three tables. One is company then expense and the last is trip report. What I need to do or see is. If you make up a new record on Company. is there a way to have the expense table and trip report to be new for each record in company? You might get a better idea if you look at what I am trying to do at: http://tandy-services.com/tripsheet/index.php
You will see the 3 tables. If you click on Company you will see there are 2 trips. When you click on Expenses there is one for the first record in Company. Then in trip report all the records in there only belong to the first record in Company.
Now in the second record of company, How can I get the expenses and trip report to reset to the second record in Company? If that is even possible?
Thanks for any help
James Tandy