hi everyone!
it is my first project with php runner.
i am trying to convert data from an old access database.
this database contains data from customers and its contracts.
there are different types of contract.
the customers are stored in one table(customers, key=customer_id), the main data of all contracts are stored in another table(contracts, keys=customer_id , contract_id).
for each contract type it gives an seperate table with some additional data(contract1, key=contract_id contract2, key=contract_id and so on).
now the problem:
i have one main table with the customers data displayed.
when i click on a customer it shows me the contracts that the customer does have.
so far so good!
when i click on the view link to display one contract the data of the main table it displays the maindata from the contracts table. allright!
but how can i do that it displays the additional data too?
the problem is that the additional data source is different for each entry in the contracts list.
i think there must be added some code (maybe a sub query) in the view link.
but i dont know what and where!
it is hard for me to explain my problem. i hope that anyone understand! (my english is not the best)
i hope you can help me to resolve my problem and to get it work!
if someone speaks german it would be nice to msg me! <img src='https://asprunner.com/forums/file.php?topicimage=1&fieldname=question&id=4268&image=1&table=forumtopics' class='bbc_emoticon' alt=':)' />
