populating an edit table based on primary key using columns not in the viewing table

[buffanut]

@mdevaney  Thank you for the suggestion to start a new thread.

I have two tables on a screen. the first table is a view table and displays a unique identifier from a table. the second table is an edit table and has other columns from the same table that I would like to populate based on the selected row from the view table.

The problem I am running into is the table for editing will only contain the value for the unique identifier and not all of the columns. 

i've tried using this formulas, and variations of it:

     Item = Filter('[dbo].[Project List Master]',SID = DataTable1.Selected.SID)

but am getting no luck. 

Any help would be very much appreciated!

[Drrickryp]

Hi @buffanut 

Filter will not work because it returns a table and not a record.  First(Filter(Filter('[dbo].[Project List Master]',SID = DataTable1.Selected.SID)) should do the trick.

[v-yutliu-msft · Accepted solution]

Hi @buffanut ,

Do you mean that you set an edit form's Item to : Filter('[dbo].[Project List Master]',SID = DataTable1.Selected.SID)?

Actually, one edit form's Item should be one record.

While the result that Filter function returns is a table.

Please set the form's Item:

First(Filter('[dbo].[Project List Master]',SID = DataTable1.Selected.SID))

Best regards,