I have 2 tables with the following fields:
Master Table: supplier
company
name
telephone
email
ID
Detail Table: route
start_location
end_location
company
name
telephone
email
route_id
When executed the user initially enters there supplier details. This is a 1 off process.
The user then clicks the route tab and selects Add New whereby only the start_location and end_location fields are available for data entry. No other fields are to be displayed on the route_add.php page
At this point i would like the route table fields: company, name, telephone and email to be populated from its respective supplier table fields.
Thanks in advance
Lisa