A
Andy
Guest
Hi,
I have a big problem: I want to control two tables of one database at the same time.
Situation:
2 tables
In the first table I have got products with one primary key (product_id) and ten other fields.
In the second table I have got offers from different firms related to the products in table one via product_id. The second table has another primary key (offer_id).
Workflow:
1)
I want to add another offer into table 2. I search for the products (in table 1) and when it's found I want to add the new offer (in table 2) without the need to change the table by hand.
2)
I would like to add another offer but my search for the product does not return any results. How can I enter a new product (table 1) together with the offer (table 2)?
Perhaps the solutions are easily done but I cannot see them, I am sorry.
Please, can you help me here?
Thank you very much,
Andy
I have a big problem: I want to control two tables of one database at the same time.
Situation:
2 tables
In the first table I have got products with one primary key (product_id) and ten other fields.
In the second table I have got offers from different firms related to the products in table one via product_id. The second table has another primary key (offer_id).
Workflow:
1)
I want to add another offer into table 2. I search for the products (in table 1) and when it's found I want to add the new offer (in table 2) without the need to change the table by hand.
2)
I would like to add another offer but my search for the product does not return any results. How can I enter a new product (table 1) together with the offer (table 2)?
Perhaps the solutions are easily done but I cannot see them, I am sorry.
Please, can you help me here?
Thank you very much,
Andy