use table field names dynamically

Business Central/NAV Developers Forum
1

Hi All,

I have a problem of using table field names dynamically.

I need to put a SETRANGE to a table. Filtering fields are in another table.

I can take them into variables. eg. Variable1 and Variable2.

Can I put SETRANGE(Variable1,Table.Variable2) in this way.
I know, It is not working. but if there is any possibility of doing something like this, Plz anwer.

2

Can you be more clear with ex…

3

You’ll need to use RecordRef and not Record variables. With RecordRef you can access the field numbers and field names. You can then take that and use a FieldRef to set your filters. You can find examples of both all over the forums.

4

Hi Matt,

Thankz Lot. Yes it is working. Problem was solved.

Thank you again