JaySee

Hiya all, I would like to be able to have filemaker not show a border when i am in browse mode, i.e. when the field is selected, i get a black outline, regardless of the bordering of the field... is there a way around this? I want a custom outline around the field (not black nor straight square) thanks, john

Thank you so much to both of you!! It's working just as it should now, and it makes sense what was wrong... As always, it's a simple fix eh? John

Hiya all, I've got a problem when using the set field command in FMP that has got me stumped! When i want to set data to a related field I can do it, but only if i have pauses in it. If i take the pauses out, the system ignores the set field lines of the script... I've attached the file so you can take a look, Thanks in advance, John

I've not come accross "behind buttons", can you enlighten me? maybe I'm just calling it something different...? thanks, john.

Thanks for the reply. I had sort of resigned myself to a script of some sort... <<<You can create this script as Openning script/exit script/Behind buttons to make sure the list is always kept updated as per items.>>> What do you mean by this exactly? How do you create a script to work this way? Thanks, john.

Ok, here's the way the system works: A = the stock file. this is essentially a set of records, each one corresponding to an item / serial number that is in stock in the company. B = the items file. this is the items database, the itemID links to the stock file, i.e. looking at the stock file tells us how many of a given item we have in stock... items holds the info regarding item description etc. D = the transactions file. this is where all the invoices are stored. they have a unique transaction item, but do not have the actual goods being sold on them. These are viewed through a portal to file C C = the transactions items file. I.e. this is where each item on a sale has an record. On each record, there is a portal into the original stock file, that gets the serial number and item code. because on any given line all the codes must be the same, i have a simple calculation field that is actually IN file C to show the code, which is portaled into the transactions file (D). The problem is this. I need to generate a list of all the serials on a given record in C, such that I can look at it through the portal in D. So I have a list of records (and hence serial numbers) in a portal in C, which I need to sumarize into one field (with ";" between them or something) so I can look at it from file D. Arrrrgh, if only i could look at a portal through a portal! thanks, john

Hi there all, I'm sitting here going crazy trying to figure this one out! Can anyone tell me how to achieve the following? I have a database called "A" which contains all the serial numbers for any item ID in another db called "B". What I have done is in a third database called "C" made a portal that sees these serial numbers. This is all working fine, all i need to do now is be able to generate a list of the serial numbers in a different field in file C so that I can look into it from another file (D)'s portal. Any advice on how to do this? I've racked my brains! thanks, john.