In form view in Main table (red table) Everthing is OK.
But when i export records in Excel from main table (red table). It loose relation between Phone (Телефон) and IP
this is could happen if you have more than one related SIM card per phone (which seems to be the case) and your layout is not showing the first.
Are the related fields on the layout in a filter or sorted portal?
Did you use Export records or Save as Excel?
I use Export Records. When use save as excel everything is OK. which is more correct ?
Both are correct, doing 2 different things:
Save as Excel reproduces what you see on screen, whereas Export records will use the database schema (relationships and their sort order) to determine what row should be exported).
I'm sure you'll understand better if you look at the raw data and find KOM and SIM records for a given телефон.
I Understand. I'm disappointed. I do not have well structured relations. I want to get the right results through both export and save as.
You can achieve this but you’ll need other relationships.
Can you give me some help and guidance ?
Different result doesn't mean your relations are not well.
"Export Records" often disappoint ones who want not empty value in main fields. (But this is not your issue now)
I'm not sure but adding an (unstored) calculation field in telephone table, refer IP, then use it for export would resolve.
I'd suggest the same, but without a data sample it is diffcult to help.
Ok. I understand.
I can send you private massage with my database ?!!!
of course but if you’d post screenshots of your 3 tables in table view without the personal data, you’d have an entire community at your service!
When i export from "КОМ-комун. устройство"
everything is OK. But when I export from the main table, I lose the link between ID - Фаб. номер ком. устройство - Телефон - IP
Retrieving data ...