Auto Enter Data from Another Field

[waymon]

Hey all,

I have 2 tables. Producer and Inventory. The tables have a relationship with each other using the field named "XSAN Number"

The inventory table has a field named UPCs.

So I have a bunch of records with UPCs that I want copied to one field in the producers table.

I want to create a field in the producer table that continually gets updated every time a new UPC gets entered in the Inventory.

So the producer table can locate the XSAN Number they want and it displays all the UPCs for said XSAN Number in a field. (Combined UPCs?)

Thanks a ton!

Edited September 30, 2010 by Guest
ID Field Type

[comment]

Why not use a portal?

[waymon]

I can't get my portal to display all UPCs from all records at once. It just display them like it normally does.

Id also like it to skip records that don't have any UPCs. So I don't get any spaces in the portal.

thanks!

[waymon]

So I kinda figured it out, but I would like it to skip all records that don't contain any data.

See how I have a bunch of blank space before it display any data?

[comment]

Well, the best way would be to not have "records that don't contain any data". Alternatively, you could filter the portal to show only records that have data of interest.

[waymon]

I guess what function would I use in the filter for 'data only'?

[comment]

Try:

not IsEmpty ( Inventory::Somefield )