Having slight trouble with look ups. Have two tables containing name and part number in each this is working just the way i need. When ui look up the name all the part numbers re;ated to it pop up.
However i also have 3 address fields in each and customer name. If i try to create a relationship between the address fields my other look up doesnt work!!
so what i need my second look up to do is when i select my customer i need the address to come up automatically.
any help greatly appreciated. using fm 10