lookup rule with 2 tables

replied on August 19, 2014

You can create lookup rules to automatically populate fields with information from a database. Does your product table contain information about the supplier? If so, create one rule that will populate the supplier name into the Supplier drop down field, then create another rule which will populate the Product drop down field based on the information selected in the Supplier field:

Hope that helps!

0 0

replied on August 19, 2014

I think you are missing the problem.

You should check out the use of a stored procedure.

Or in a modified sense, you can do what is listed above, but maybe in a different sense.

Can you give us an indication of what the primary key is between the two database tables? if it is simply the supplier, then you can use the products table directly. If not, then you will want to use a stored procedure or a view for what you want.

1 0

Question

Question

Replies

Sign in to reply to this post.