aussie

i need to create a field that shows a running_count and the sum of the count. eg parent_id=9011 record_id=1090 count_calc = "1 of 4" parent_id=9011 record_id=1095 count_calc = "2 of 4" parent_id=9011 record_id=1168 count_calc = "3 of 4" parent_id=9011 record_id=1247 count_calc = "4 of 4" i can get the sum_count by using the sum function in the parent file but i'm having trouble with the running_count. any help would be greatly appreciated.

can i assign a background color on a field depending on the result of the field. eg field="Yes" background="Green", field="No" background="Red"

i have a field with a strict restriction calculated using the result of another field. i don't want the user to be able to proceed if the condition is not met. it would work fine if the 'revert field' wasn't an option on the strict message. any way of not showing it?

when i tab into a portal row the lookup defined for a field in the file doesn't work. however if i click into the portal row the lookup works fine. any ideas?

i need to 'combine' two separate product files into 1 value list showing product_code, product_description fields which are in both files. any help appreciated.

just a few questions on when and how to perform a script. * can i perform a script when a field value changes ie. when user changes fielda script performs: if fielda="option1" goto layout "1" if fielda="option2" goto layout 2 * can i perform a script before i exit a record. used for exteral error checking. * is it possible to modify a calculated record? i have lookup fields that use a field that may be changed later so i need to 'relookup' the result. if i could modify a calculated field it would be simpler. thats all for now. any help will be greatly appreciated.

hello everyone, i am relatively inexperienced with fm but have done a lot of work with msaccess (forgive me please ). i have files for job/item/products with the relationships 1 job to many items. 1 item to many products. i want to select a job and have a portal showing the related items and within the items portal have another portal showing the related products for that item in the portal row. is this possible? any help would be greatly appreciated.

thanks LiveOak and Rigsby for your replies. just one more ? for this one. if i use a self relationship in the file to use in a portal how do i display every record for that file. ie suppliers file with supplier id i need to create a portal showing every supplier.

good morning all, i have created a layout format and want to insert a list view into a specific area of the layout. ie i need the list view to look like a portal. any help would be greatly appreciated.

i have created files for suppliers, products and supplier_products. in the supplier_products file i want to restrict the data to only 1 instance of supplier and product. ie i want to create a combined primary key of the foreign keys supplier_code and product_code. eg supplier_a,prod_a supplier_a,prod_b supplier_b,prod_a if the user enters supplier_a,prod_a again i want an error to occurr due to file validation. if that makes any sense to you i would appreciate your help.

i have created a portal of customer_contacts for a customer. the customer_contacts row displays name, phone and email. i want to be able to click on the portal row and open the customer_contact form for the contact that has been clicked on. any suggestions would be greatly appreciated.