Radicore Forum
Fast Uncompromising Discussions. FUDforum will get your users talking.

Home » RADICORE development » Application Development » Updating records on many to many relatioship
Updating records on many to many relatioship [message #3656] Sun, 07 April 2013 03:14 Go to next message
edortizq is currently offline  edortizq
Messages: 82
Registered: August 2008
Location: Ecuador

Hi Mr. Marston, please help me to solve this issue:
I have 3 tables wich are used as a MANY(parent)->LINK->MANY(child) relationship, I'm using the Link1 transaction to create the LINK table, but I want to update the table MANY(child) using a form as used in the Multi2 transaction.
The expected functionality is:
- Select a record from the table MANY(parent).
- The transaction form shows the records of the table MANY(child) associated through the table LINK, one of the fields of the table MANY(child) will be updated.
- Pressing SUBMIT button then the records of table MANY(child) are changed.
What is the better way to do it?
Thanks for advance!
Re: Updating records on many to many relatioship [message #3657 is a reply to message #3656] Sun, 07 April 2013 04:52 Go to previous message
AJM is currently offline  AJM
Messages: 2275
Registered: April 2006
Location: Surrey, UK
Senior Member
I suggest you take a look at http://www.tonymarston.net/php-mysql/dialog-types.html#choos e.link1.list2.multi2 for a list of possibilities.

Previous Topic: Print reports automatically
Next Topic: Button on a detail record of a list transaction pattern
Goto Forum:

Current Time: Sun Nov 28 15:47:43 EST 2021

Total time taken to generate the page: 0.01090 seconds