get field vlaues form other table without code ?

hi, i have a form for a table in which i save articles … their is another table in which the seller names are saved … both are related using an id field. in my form i want show the real name saved in the other table and not the id which is saved by the article. i know how to solve this with some code but i tried to solve it wihtout code using the tablerelation and sourceexpression of a calc field … but it doesn’t really work maybe i don’t fill them in the right way … so i ask you if this is possible or not … thx

Take a look at how the customer names and addresses field in the Jobs table are defined. That should help you. Lars Strøm Valsted Head of Project and Analysis Columbus IT Partner A/S www.columbusitpartner.com

Create a flowfield of lookup type. The examples listed above are of that type. Bill Benefiel Manager of Information Systems Overhead Door Company billb@ohdindy.com (317) 842-7444 ext 117

thx, now it really works fine :slight_smile: *** quack ***