Hello, i'd like to know if there's a way to display multiple fields when using lookup
i have 3 forms (Products, Customers, Orders)
Products contains
ID
Product Name
Product Cost
Sale Price
Customers
ID
Customer First Name
Customer Last Name
Customer Phone Number
Orders
Customer (linked to ID field in Customers form)
Product (linked to ID in products form)
i want to only store the customer id and product id in the Orders form,,yet i want the other info (customer name..product name..etc) to be visable when i'm adding an order
it's possible to view them on the report of Orders but not while i'm creating an order
i tried to do a work around by adding these fields to the Orders form and then update them using script when the product or customer are selected..but then i'll have to store those values again in the Orders form
is there anyway to display them? without the one that displayes them next to each other seperated by "-"