Need help with some issues following upgrade

[eSBee]

Hello all

I'm a newbie to filemaker but have recently upgraded from v5 to v7.03. I had a major problem logging into the database which I think I've solved now but I guess only time will tell.

Now, I've got a couple of issues with some of date fields, which are displaying ? (question marks) instead of the date but if you click in the date field the date's actually there. Can anyone tell me how to display the date instead of the "?" ?

The other problem I'm having is that when I try to create a new blank record from using a button on another file the data to be transferred from the fields with the button does not appear on the new record layout. I'm sure that wasn't clear so here's an example:

I have 2 files, CUSTOMER and ENQUIRY.

On the CUSTOMER layout there's a button to create a new enquiry record which takes some of the contents from the CUSTOMER layout over to the ENQUIRY layout. However, this is not happening most of the time. When you click the New Enquiry button it only takes the CUSTOMER NUMBER field data over and not the other customer data.

Does anyone have any ideas why this would be happening? In version 5 it worked without a hitch. Any help you can give would be most appreciated.

Many thanks

eSBee

[transpower]

1. In layout mode, stretch the date fields. If that doesn't help, check the date options you have selected.

2. Put the customer fields directly on the layout for Enquiry. When the record is created by script (with customerNumber as the foreign key), the other customer fields will be displayed. Of course, in your Relationships Graph make sure the primary and foreign keys (i.e., customerNumber) are linked.

[eSBee]

Thanks for getting back to me.

1) My date fields have been set-up to use the custom format and would only appear if I choose the leave as entered option but then the dates are not correct as spaces are missing etc. I have been testing exporting them to Excel and re-importing them which seems to work ok but will be a lengthy process as I have 10 files each with at least one date field and 10k records.

2) My customer fields are currently on the enquiry layout and there is a 1:m relationship link in place, hence the frustration in figuring out why it is not working.

I will continue to investigate this as the problem does not occur for every new creation. Any further suggestions would be most appreciated.

Many thanks

eSBee

[eSBee]

Hello

I thought I should post my scripts for the CUSTOMER and ENQUIRY files in the hope that someone more experienced with script writing might detect a flaw if there is one.

CUSTOMER SCRIPT

Copy [select; customer::Customer Number]

Open File [

[eSBee]

Sorry, but can anyone tell me if there's a problem with the code in the above posting? If it is correct I don't understand why the data is not appearing on the screen.

Many thanks

eSBee

[Ano Nimus]

Maybe it works better if you do this?

CUSTOMER SCRIPT

-> Goto Field customer::Customer Number

-> Copy

Open File [

[Vaughan]

You are not specifying a layout in the enquiry script. Not only are the copy and paste steps layout dependent, in FMP 7 layouts are tied to tables, so you need to specify a layout to specify which table you are adding records to. Try these changes:

CUSTOMER SCRIPT

Go to Layout [layout with customer::Customer Number field]

Copy [select; customer::Customer Number]

Perform Script [

[eSBee]

Sorry Vaughan, today was the first opportunity I had to test your suggestion and unfortunately, that did not work.

I think that I have resolved the problem however, by simply adding the Commit Record/Request at the very top of the Customer Script. Will have to continue testing and post again if there still seems to be a problem.

Many thanks for all your help

eSBee