I'm starting to recreate a solution "trying" to do Data separation.

I have 2 files: File A interface, and File B Data with 8-9 tables

I have a table "Services" in B that contains different records holding info
about different services I provide.
So, one field is " service description", another is " Insurance Code",
another is " Cost for service" and one for " Date of service" and so on...

In File A (Interface) I have a layout with a portal linked to another table
"Services rendered" for ex. in B.
I can provide a service in A and it creates a sale in the Service rendered
Table in B.
Something like an invoice.That works.

What I'm trying to do is: when I provide a service for a patient, I want to
click in the portal (in the interface file)
on the "Service description" Field, select the appropriate service
description from a list and automaticaly have
the other fields in that portal lines show the Code, Cost. I think it's
called a lookup.
I can get the list of "service description"from the services table in B. BUT
it doesn't fill out
the insurance code, cost , etc.

It used to work in my old solutionFM 5.5 but I can't get it to work with FM8

Any suggestions

Thanks

As far as data separation goes, you should be working with the tables
as if they physically exist in the interface file. The only exception
to this is that lookups, auto-enters etc. need to be setup in the data
file.
Assume you have the table "Service" and the table "Patient".
You want the "Patient::Cost" to lookup its data from the
"Service::Cost" when you select the "Patient::Work Done".
Create a link from "Patient::Work done" to "Service:escription"
Make "Patient::Cost" lookup the "Service::Cost" using the link you just
created.
All of this was done in the data file.

Now in your interface file from somewhere you have a portal to
"Patient".
You have a value list of all service descriptions attached to the
"Patient::Work done" field in that portal.
When you select a service description for the "Patient::Work done"
field the "Patient::Cost" will automatically update.