Help needed with dynamic link
I have a Customer I’m working for that would like “dated notes” for different tables.
I have created the two tables - COMPANIES - COMPANY_NOTES
the relational field is “customer_id”
The primary key for COMPANIES is customer_id
The primary key for COMPANY_NOTES is note_id (but it also contains customer_id)
I have used the DataAssist Wizard to create all of the pages for both tables
I wanted to just have a hyperlink from the companies_Detail.php that would use a dynamic hyperlink with the S_customer_id
company_notes_Results.php?S_customer_id= <?php echo $row_WADAcompanies['customer_id']; ?>
However that is not working because of the x.Search and y.Search variables it is expecting a URL like this “company_notes_Results.php?S_customer_id=5&Search.x=33&Search.y=4&Search=Search”
And some companies are going to have multiple notes on their account.
Does anyone have any suggestions to achieve a dated note system or can you help me correct the mess that I’m in now. Maybe I’m going about this wrong any suggestions would be appreciated.