Problem with Lookup Function
I created a form which does a lookup for PO number from another form, this works fine, however when I try to lookup a second field which contains the PO Name information from the same form using the first lookup results as a filter I get a type mismatch saying I can not use that because it is a BIGINT format, but it was created as a string. Why is is converting this and how do I get around it, or alternately how do I bring multiple fields across in a lookup function and display them in separate fields in the new form based on the first lookup function? I have looked to see "existing links" when I create the second lookups but none are shown as existing? This is very confusing to me, sorry but I am a newbie.