PDA

View Full Version : A4V6 to A5 set links problem


ABC123

gregtcm
02-21-2007, 05:06 PM
Hi all,

I've been using A4 for many years and built a number of applications for my company, one of which was a divisional breakdown for wages costings.
In A4 the main imput set consisted of 2 databases 1.Week and 2.Hour (there are monthly ones but this will suffice as an example.

The three main linking fields in A4 were TCM_EMP_NO, WEEK_NO & TAX_YR_END. The primary record entered into the week database would link to all the minutes spent on different divisions for a week period for each individual employee, thus Week and Year references were required as the years went by to avoid the wrong records in the child table linking to the parent.

After entering the employee number, week number and year number (all numerical fields) in the week db part of the entry form and then tabbing down to the hour table would alow entry for all that weeks time split details.

Worked like a charm for years and with basic reports would result in single entry into the payroll and accounts programs for each employee giving "to the minute" divisional labour splits.

BUT! conversion to A5 PROBLEM!!!
Copied the 2 DBs (and an emloyee Db used as a lookup) made Week the primay and tried to use a 1 to many link as I had in A4. The common field/expression in A4 was:-
str(TCM_EMP_NO,3,0)+str(WEEK_NO,2,0)+str(TAX_YR_END,2,0)
I have tried numerous ways to vary this in A5, bit it results in an error message.

Wth Just fields added it results in a link that sums the field values and picks up records that match the total!
This must be basic stuff but it has me baffled at the moment!
This is my 1st time on the board, I'm from accross the Pond, your help would be much appreciated.

Stan Mathews
02-21-2007, 05:11 PM
Do you feel like sharing the error message or is that sensitive information.

gregtcm
02-21-2007, 05:15 PM
no problem but will have to recreate the set links. I will do this and post the error message on this thread in the morning. Thanks for coming back. Greg.

Stan Mathews
02-21-2007, 05:45 PM
no problem but will have to recreate the set links. I will do this and post the error message on this thread in the morning. Thanks for coming back. Greg.

I just created what I think you described and had no problems. If you download the attachment, unzip it to a directory separate from your application and add it to your database or create a new database in that directory for examination.

gregtcm
02-22-2007, 05:22 AM
Morning Stan,
This is a bit embarrassing! During recreation of the set links this morning I suffered a Homer Simpson moment. Too many years of Excel spreadsheet design have taken their toll, expressions do not have to start with a "=", Doh!
Bet I won't make that mistake again.

However, in A4, this link would still allow cascading changes and deletes (and with a prompt, which was useful as users would pass the question on to others if they weren't sure rather than just deleting child records. Not so much in this Set, but certainly in others). Is there any way to do this in A5?

Thanks for your help.

Greg.

Stan Mathews
02-22-2007, 09:13 AM
That's a setting in the link definition, referential integrity.