Welcome, Guest
Username: Password: Remember me
  • Page:
  • 1

TOPIC:

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

  • iconvisual
  • iconvisual's Avatar Topic Author
  • Offline
  • Senior Member
  • Senior Member
  • Keen Joomla! 1.7 Developer
  • Posts: 53
  • Thank you received: 5
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.

Please Log in or Create an account to join the conversation.

  • Page:
  • 1
Time to create page: 0.051 seconds

  I found "cook" two days ago. Played around with it for a day and then within a day got rid of two legacy applications in IBM Lotus Domino Notes and replaced them with "cook". It was really easy. A piece of cake. Actually it was even easier than cooking. Cooking involves more work than developing with "cook". What can I say about "cook"? Great application great price for what it delivers great forum with a lot of information and fast responses active and friendly community fast forward moving development cycle So what should I say "Monsieur Le Cook"? Keep the good work going it will lead to success. Having become a paying member in the words of Edith Piaf may I say ..... non rien de rien ... je ne regrette rien. Vive La France.
FK (JED)
         

Get Started