Options

Show all tables data

SaifB2MSaifB2M 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

  • Options
    StarvingForLearnStarvingForLearn Member Posts: 6
    Use tablerelation with condition on tableID for the field RecordID
  • Options
    SaifB2MSaifB2M Member Posts: 6
    Can you provide me with more details please ?
  • Options
    vaprogvaprog Member Posts: 1,118
    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.
Sign In or Register to comment.