Welcome, Guest
Username: Password: Remember me

TOPIC: Foreign Keys display/edit in Main Entry Form?

Foreign Keys display/edit in Main Entry Form? 01 Mar 2012 00:37 #1486

  • iconvisual
  • iconvisual's Avatar
  • Offline
  • Senior Member
  • Keen Joomla! 1.7 Developer
  • Posts: 53
  • Thank you received: 5
  • Karma: 1
Hello All,

In my Project I have (as an example) 2 Tables.

1. "Sales Leads": it contains all captured sales lead data, AND it contains a Foreign Key link to another Table called "Diary Notes".

2. "Diary Notes": contains notes relating to a Sales Lead.

So, I have a One to Many (Sales Leads ->> Diary Notes) relationship.

When I create a Front End Layout to Add/Edit a Sales Lead I want to be able to have the user Click On a Link/Button that will popup a Add/Edit Diary Note entry which will be linked to that Sales Lead.

Can some kind person suggest a way in which I could accomplish that?

Thank you in advance for your time and assistance,

Regards,

Edward
Keen Joomla! and PHP/MySQL developer. Excited about J-Cook.
The administrator has disabled public write access.
Time to create page: 0.060 seconds

Get Started