Use filter or Lookup to show a selected value connected to another table

[RikardE]

I posted this in connecting to data but figured it might get more response in the general discussion.

Please contact me if you don't understand the issue. 

I have a Detailform which retrieves information from another screen.

So in this example I have pressed my Sales order "000002" and gets to my detail screen.

I have managed to get the "company" and "Sales order" data by using my DataSource "SalesOrderHeaders" and set the Item to "BrowseGallery2.Selected". (Which is the name of the screen where I selected my Sales order).

I also want to retrieve the Item number but this is from another table called SalesOrderLines. I want it to match with my Sales order number "000002".

Can I use Filter/Lookup to get data from my SalesOrderLines and match it with the Sales order number somehow?

Thanks for the help

[Meneghino]

If there is a one-to-one relation then use LookUp, if one-to-many then use Filter.

Please let me know if you need details, but being specifc with the issue you are facing in using these functions (i.e. what you tried and what you got)

[RikardE]

Thank you,

Well, I have tried to do a filter but I can't get it to work.

Not sure if Im doing it correctly.

Filter(SalesOrderLines,SalesOrderHeader.SalesOrderNumber = BrowseGallery2.Selected.SalesOrderNumber)

So I want it to the get the SalesOrderLines that is connected to the SalesOrderHeader.
I chose the SalesOrderNumber in my BrowseGallery2.

[Meneghino]

Rikard, I suggest that we Skype next week (Wed-Fri) so I can show you what needs doing.  I will send you a private message with my contact.

[Mike8]

Hello RikardE,

Let's name the column of SalesOrderLines table that has the Item number that you need ItemNumber.

Does the following, work for you..?

LookUp(SalesOrderLines,ItemNumber= BrowseGallery2.Selected.SalesOrderNumber,ItemNumber)

(Replace ItemNumber with the actual name of your column)