Many-to-many relation

This topic is locked

Many-to-many relation	11/8/2019 6:24:30 AM
PHPRunner General questions
O Olav author Hi. I have 3 tables: CONTACT, PERSON, CONTACTPERSON CONTACT: ContactID, ContactName PERSON: PersonID, Firstname, Lastname, Phone, Email CONTACTPERSON: CustomerPersonID, ContactFN, PersonFN Under table CONTACTPERSON, I would like to add several Persons ADD: PersonID (Store PersonID in database, but Lookup from PERSON Fullname with phone) List: CONTACTPERSON, I would like to inline edit Phone also) How can I do this in PHPRunner?


J	jackwood 11/8/2019
	Hi. I have 3 tables: CONTACT, PERSON, CONTACTPERSON CONTACT: ContactID, ContactName PERSON: PersonID, Firstname, Lastname, Phone, Email CONTACTPERSON: CustomerPersonID, ContactFN, PersonFN Under table CONTACTPERSON, I would like to add several Persons ADD: PersonID (Store PersonID in database, but Lookup from PERSON Fullname with phone) List: CONTACTPERSON, I would like to inline edit Phone also) How can I do this in PHPRunner? Hi , Take a look this blog. https://xlinesoft.com/blog/2011/02/28/how-to-setup-many-to-many-relationships/