Hi,
I have a tabele with two types. In and Out. I would like to add some information from In to Out. It is connectet via second tabele. How can I create link between in and out?
Expected results
document no. -> direct fields from tabele1 with type out
Ref no -> direct field from tabele 1 but I must find document with type in
Sources:
Tabele1 - type, document no, ref
Tabele 2 - type (different than tabele1), document no (the same like tabele1); serial no (the same on all types in this tabele)
Hello -
In what way are the two tables related?
For example: for OUT01, you want Ref2. Is this because there is a 2 in the serial no. field in table #2?
or... because I have the second OUT record (OUT02), I want the reference for the second IN record (IN02)?
For example: is this how they relate?
Hi, Those tables are related via doc no. only. Reference and serial no. are separate data.
Ref2 is a data what I want to assign to OUT document (your no 4)
Data explanation
Tabele 1
Doc no - internal NAV number different depends on type (Table 1)
Ref - customer reference (every time different)
Tabele 2
doc no - the same numer like tabele 1
type - different document type not related to type in table 1. It can be filter to find in and out document
Serial number is a link between in and out document in table 2.
So, if I'm looking in Table_2 at the record for OUT01... its serial number is 2.
When I look at Table_1, do I want the "ref" value for the corresponding "in" record that as a 02 at the end of the document number?
I'm not sure I correctly understood your question.
"Out01", "in01", "ref1" - all of them are full numbers. It is not necessary to split "out - 01"
Field document number is a link between table 1 and table 2