Two tables to one record?

If you're a new user of AppGini, feel free to ask general usage questions, or look for answers here.
Post Reply
User avatar
TandyServices
Posts: 15
Joined: 2015-12-07 22:59
Location: Largo, Florida
Contact:

Two tables to one record?

Post by TandyServices » 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

User avatar
TandyServices
Posts: 15
Joined: 2015-12-07 22:59
Location: Largo, Florida
Contact:

Re: Two tables to one record?

Post by TandyServices » 2015-12-12 15:54

I figured it out..

Post Reply