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

Linking fields to allow auto entry


Recommended Posts



Is there a way to link fields, so that if a code is entered in one, data is automatically entered in others?


For example, if a product code is entered in one field, can this automatically generate a product description in another and a price in a further field?





Link to comment
Share on other sites

Dave, one way to do this is to have 2 tables. The first would have 3 fields: product code, description, and price. The second table would have one field (product code), and would be linked to the first table through that field (product code related to product code). In the second table you would also have a description field and a price field, but these would show data from the first table (drag a field onto the table 2 layout, and in the field setup, "display data from" window, choose the first table and select the field. To make it easy to enter the product code in the second table, you can make that field a drop down list referencing the product code in the first table.


This is probably quite a bit more basic than you probably need, but I hope it will give you a starting point. I've attached a file as an example, but if you're not a member, I'm not sure that you can download it.

Link to comment
Share on other sites

This thread is quite old. Please start a new thread rather than reviving this one.

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.

Reply to this topic...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

  • Create New...

Important Information

Terms of Use