hide fields in record

[transit]

Hi all

i have a db with lots of fields. Some records need all the fields and some records only need a few fields.

Is there any way i can select what fields can be seen in a record?

many thanks

[bcooney]

This sounds like a data modeling issue rather than an interface issue. Perhaps you can be more descriptive of what you have and we can suggest an approach?

[transit]

i will try to explain better.

the db has 10 fields

record 1 shows fields 1,2,3,4,5

record 2 shows fields 3,5,6,9

record 3 shows fields 8

record 4 shows fields 9,10

etc

is that any better

[bcooney]

Actually, yes. It sounds like you have a very bad design going. How about telling us what the real fields are and what tables you have. Then, we could propose a better structure.

[transit]

it is a db of deliveries that a van driver makes.

each record is a delivery site.

each field is an item from the warehouse.

the van has a computer screen which shows the next delivery site/record. At present the driver has to scroll down the record through the fields to see what he is to deliver, and then goes to next record to see the next delivery site.

I want it so that the driver only sees the delivery site he has to go to and only the fields/items he has to deliver at that site.

hope that helps.

[bcooney]

Each record is a delivery site? and I just noticed that you're in FM5. Really?

Well, I think that you need each record to be a delivery with a site (from the Sites table) and that is related to a route, perhaps and a deliveryItems table. So, each driver would find his route, then his incomplete deliveries.

I don't have the time to redesign your entire system. Sorry. Maybe someone else might and will chime in.

[transit]

Well, I think that you need each record to be a delivery with a site (from the Sites table) and that is related to a route, perhaps and a deliveryItems table. So, each driver would find his route, then his incomplete deliveries.

Not quite what i was looking for.

As usual with me, i think i cant explain what i am wanting. Maybe i will do what i usually do, bumble about!

[comment]

It's true the explanation is somewhat incomplete, but it is enough to make it perfectly clear your structure is the problem: you need to show the items in a portal to another table, where each item is a separate record.

[transit]

yes the penny may have dropped.

i think i did this for my invoicing some year ago, but have forgotten how to do it. Bit of reverse engineering i think.

"i may be gone some time"

[transit]

ok i am well on my way to sorting my problem.

thanks to bcooney and comment for opening my eyes.