I am a new user to FM but am a user of MS Access.

I am tying to change a file over from MS Access by writing a new DB using FM 12 pro. I have imported a product table a supplier table and a product type table(Chem Code).

TheCem Code table is related to the product table so that each product belongs to one  "type".

I have also created an order table and a line item table in FM.

I have been successful in relating the products ordered through the line item table but am unable to get the "type" to auto enter from the Chem code table at the same time.

I need to do this so that I can then group on product type later.

In MS Access I could do this by using queries my relationship graph looks like this

 

ORDER   order_LINE ITEM      order _lineitem_PRODUCT    order_lineitem_product_CHEM CODE

 

I can not pick up the type from the chem code table

perhaps it is because I have imported the data  

 

I would like to send the file but don't know if that is possible

 

If you can help

Thanks

 

H

Please could someone move this to where it should be posted

 

thanks

 

H

I am not sure why you need to duplicate the type value to another table. If you have a chain of relationships like:

 

Orders -<  LineItems >- Products >- ProductTypes

 

then each record in LineItems can "see" the value in the (only) related record in ProductTypes and work with it directly.

 

If you need to have it as a local field (e.g. for using it in a GetSummary() function), define a calculation field in LineItems =

ProductTypes::ProductTypeID

or =

Products::ProductTypeID

Automatic message

This topic has been moved from "FileMaker Pro 12" to "Calculation Engine (Define Fields)".

Fair comment

perhaps it would be easier to have a drop down list in the products table for item type

It just means filling in the 450 records with the Chemical group (item type) at least then I should be able to group on the item type.

I will try this

 

Thanks

 

H