I have two tables: Sender and Receiver. Tables have relationship on Sender_id and Sender_id_fk. On the Add form page of the Receiver table I have a dropdown buttom which lists all Senders names to choose from.
- When selected one from the list, I want to show the details of his/her related Receivers ( names, tel, etc) on the same from on the left.
- A use can then select the related previouse receivers to populate the form field automatically.
Problems:
- On the desinger, when insert fields from the sender table it doesn't recognise and shows sql error.
- also need Ajax or JavaScript code to populate the fields.
- Thanks in advance