G'day Craig,
At 11:29 8/05/01 -0400, you wrote:
>I am in the process of attempting to convert to Windows 6.5+ from 4.5+ and
>am having a problem with an order entry form - namely, I am unable to add
>more than one row to the second table (line items) on the form. The form
>is brought up with the "Enter Using ... For 1 Row". The line items table
>is the second table on the form and as such should not be affected by the
>"For 1 Row" constraint. When I try to add a 2nd row (tried [F2], from the
>menu, and with a push button), it saves the 1 row for both tables exists
>the form completely. I would suspect that it is exiting because adding
>another row is violating "For 1 Row", but since I am defiantly in the 2nd
>table when attempting this (on a separate page, no columns or variables
>from the first table are on this page, have to hit [shift]+[F8] to get
>there), I'm not sure what the problem is. I've been scratching my head
>over this for over 2 days now, any suggestions would be greatly appreciated.
You did better than I! I set an autonumber on my TranHeader table,
created a form such as you describe and tried it. When pressing
[Shift]+[F8] focus obviously shifted to the child table (as the button text
on the parent table greyed) but the form display stayed on page 1.
If I press [F2] to add a row to the child table the form closes and I am
back to the R>.
My normal procedure is to:
1. programmatically insert a row then
2. Get the row id with a
SELECT HeaderID INTO +
vHeaderID IND vi1 +
FROM TranHeader +
WHERE COUNT=INSERT
then
3. call the form in EDIT mode and disallow adding rows to the parent table
in the form.
Works like a charm.
Warmest regards,
Tom Grimshaw
coy: Just For You Software
tel: 61 (0)2 9552 3311
fax: 61 (0)2 9566 2164
email: [EMAIL PROTECTED]
mobile: 0414 675 903
street: 3/66 Wentworth Park Rd Glebe NSW 2037
post: PO Box 470 Glebe NSW 2037 Australia
temp web site: 210.9.46.35
_/_/_/_/_/_/_/_/ _/_/_/_/_/_/ _/ _/ _/_/_/_/_/
_/ _/ _/ _/ _/
_/ _/ _/ _/ _/
_/ _/_/_/_/ _/ _/_/_/_/_/
_/ _/ _/ _/
_/ _/ _/ _/ _/
_/ _/ _/ _/_/_/_/_/
