Show all tables data

SaifB2M
SaifB2M Member Posts: 6
edited 2022-12-12 in NAV Three Tier
Hello experts,

I have two fields in my table, TableID and RecordID.
TableID is for selecting the Id of any table in NAV, I have no problem with that, but the second field, RecordID must contain all records of the table that I had selected when I filled the field TableID.
EXP : I entered 18 in the field TableID, so the field RecordID must contain all the records from table customer.

Im using NAV14BE

Any idea how can I do that ??

Answers

  • StarvingForLearn
    StarvingForLearn Member Posts: 6
    Use tablerelation with condition on tableID for the field RecordID
  • SaifB2M
    SaifB2M Member Posts: 6
    Can you provide me with more details please ?
  • vaprog
    vaprog Member Posts: 1,161
    A value of type RecordID contains a reference to one row in one table. Therefore a field of type RecordID cannot
    SaifB2M wrote: »
    ... contain all the records from table ...

    Either you are not exact in your wording the question, or your approach so far is fundamentally wrong it it's structure.

    Moreover, this does not make any sense seen from a relational database design perspective.

Categories