Jump to content
Sign in to follow this  
rongobong77

Having a field in One table be equal to a field in the first line of a portal

Recommended Posts

I have developed a filemaker Database to keep track of my companies Inventory. It ranges anything from details of that Inventory item, Descriptions, Images... .etc.

It also keeps track of Shipping.

I have provided a very reduced version of my database to address the tracking issue I have come up with.

There are 3 Main Tables for my database.

1. Inventory Information - this is where all the main information is kept for our inventory items. Each Item is assigned an inventory Number that is unique.

On this screen is a portal relaying information from another table...

2. Transmittal Details - This keeps track of which inventory items are on which Transmittal

3. Transmittal Info - This table keeps track of Where each shipment is going to, coming from, and when.

My dilemma is I need two fields, "Current Location" and "Current location Company" in the item information screen to automatically update or be equal to the first line "Shipped to" of the portal in the item information screen which is sorted by Shipment date and time.

Can I please get some help.

I have fond other solutions to this problem, such as making a button that copies and pastes the correct info in each field, of the corresponding Inventory numbers information screen, but that is very prone to Human error. If there can be a calculation for the Location fields, it would be amazing.

Transmittal_tracking.fp7.zip

Share this post


Link to post
Share on other sites

I have developed a filemaker Database to keep track of my companies Inventory. It ranges anything from details of that Inventory item, Descriptions, Images... .etc.

It also keeps track of Shipping.

I have provided a very reduced version of my database to address the tracking issue I have come up with.

There are 3 Main Tables for my database.

1. Inventory Information - this is where all the main information is kept for our inventory items. Each Item is assigned an inventory Number that is unique.

On this screen is a portal relaying information from another table...

2. Transmittal Details - This keeps track of which inventory items are on which Transmittal

3. Transmittal Info - This table keeps track of Where each shipment is going to, coming from, and when.

My dilemma is I need two fields, "Current Location" and "Current location Company" in the item information screen to automatically update or be equal to the first line "Shipped to" of the portal in the item information screen which is sorted by Shipment date and time.

Can I please get some help.

I have fond other solutions to this problem, such as making a button that copies and pastes the correct info in each field, of the corresponding Inventory numbers information screen, but that is very prone to Human error. If there can be a calculation for the Location fields, it would be amazing.

It is even simpler than you think.

You need NO new fields.

1. Sort the relationship, not the portal

2. Drag a copy of the fields you want from the portal and onto the layout.

transmittaltracking.zip

Edited by Guest

Share this post


Link to post
Share on other sites

One issue has come up....

now that I have made that change... if i do a search for items at a current location in that field, I get back anything that has ever shipped there.

Is there a way around that?

Share this post


Link to post
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
Sign in to follow this  

×

Important Information

By using this site, you agree to our Terms of Use.