Dear All,
I have three tables with associated columns as below:
table shipment (id,date,amount,receiver_id,sender_id)
table receiver(id,name,phone,address), and
*table sender (id,name,phone,address).
receiver_id and sender_id are the FK referring to id field ofreceiver and sender table respectively.
Everything works fine, however, except for "Add new Shipment" requirements as below:
- Instead of doing lookup, I need to show in the Add new Shipment page following column:
- date, amount, -------- receiver name, receiver phone, receiver addres----sender name, sender phone, sender address
- when filling the receiver name, the user just need to press a few initial letter and then matching option came as popup(AJAX), but then the phone and address must be filled up accordingly based on name chosen.
- in case the receiver/sender is new entry, then the user can just fill the name,phone,address straightforward on the form, not in separate window.
Is this doable ? Should I modify my table (collaps all of them into single table) or mix ?
thanks in advance,
.fianchetto