Jump to content
Salesforce and other SMB Solutions are coming soon. ×

Displaying multiple records from another file


baffled
 Share

Recommended Posts

We have two linked databases ("contacts" and "jobs").

 

It is necessary to pull in one contact into a layout in the job database as a customer. We then need to pull in four further contacts (from the same file) as potential suppliers on that job, together with their addresses and phone numbers from the first database.

 

The problem we have is that using whatever method all names and addresses will automatically populate with the (first) contact details - i.e. we are only able to import one set of details not five (although we can select five different customer/supplier names by value tables)

 

Help please!!!!

Link to comment
Share on other sites

Well, if it were a paper form you wouldn't have just one set of name and address (city state zip etc) fields, would you? No, you'd have one for the customer, and then room to input however many you need for suppliers, which would be separate fields in a different part of the form.

 

Given that you need multiple suppliers per form, and probably the number would vary from record to record, most of us would do the suppliers as a portal to the contacts file based on a multikey relationship. If each contact is identified by a unique serial number or other string (it should be), let's call that field Contact ID, then you create a field in Jobs called SupplierContactIDs, a text field, and a global field, g.AddContact. The latter field has a dropdown value list of all values of Contact ID in Contacts, showing also Contact Name. You put a small button next to that field that runs a script that sets SupplierContactsIDs to SupplierContactsIDs&Left("¶", Length(SupplierContactsIDs))&gAddContact, and then sets g.AddContact to blank ("").

 

Then you create a relationship between Jobs and Contacts based on SupplierContactsIDs::Contact ID, and you put a portal to Contacts on your Job screen and label it "Suppliers".

Link to comment
Share on other sites

 Share



×
×
  • Create New...

Important Information

Terms of Use