New record in child table

[Jan Mark]

Why can I not add or change a record in a child table with a one -" many relation? Either "Enter New Record" is dimmed or I can add or change, but the changes disappear when I press Save.

Grateful for any tips,

Jan

[davej]

RE: New record in child table

Jan,

If you are talking about entering a record in a browse, check and see if you have the browse set to "read only".

Dave

[Al Buchholz]

RE: New record in child table

Jan

If the records are ordered, after an entry is made, they will be reordered and may appear to disappear. But they are merely positioned in the proper spot.

Check with default browses and forms to see if the data is actually there.

[Tom Cone Jr]

RE: New record in child table

Jan,

Tell us exactly how you are attempting it. (Keystroke by mouse click).

Confirm that you see that the same behaviour using the 'default form' for the set.

-- tom

[Jan Mark]

RE: New record in child table

Dave, Al and Tom (who has helped me before),
I hope I can get this right.

One parent table, one child table, both not "read only". Opening the tables both connected records are present. In the default form of the set the child record to this particular record is not present. With parent table in default form "Enter New Record" is OK. "Change Record" is dimmed. With child browse in default form (no record showing) both "Enter" and "Change" are dimmed.

In other records with child records showing, only "Change" is dimmed.

I do hope it is possible to get something out of this mess. I don�t mention all my steps in the later stage, since the trouble seems to be at this basic level.

A can mention the dbf.files that I used for this database are from Approach. I have had trouble before using Swedish
characters in Structure, but this I have avoided now.

Will it help if I submit the files?

Jan

[Al Buchholz]

RE: New record in child table

Jan

Yes, please zip the appropriate files and attach them to a message or email them directly to one of us.

If the file is over 1 mb, then you'll have to send it directly. Contact me directly and I'll help you.

[Jan Mark]

RE: New record in child table

Al, http://cx500.gobinet.se/

Sorry for the delay, but a little accident required hospital care. I hope the files I am sending will work.

The database is for a motorcycle club where every member can have more than one bike, see member #147, Sture Lindberg. Of course every bike can also have been owned by several members.

Open set "cxglclub01" and try to add a new cycle, Reg_nummer GHA 587 to member #617, Joakim Nilsson. That cycle is present in the table "cxglmc01". I can enter it and save, but when I open the set again on that record the bike is gone. You can also try the same thing in the browse "komplettlista".

In the form "Alla medlemmar" I cannot get the Multi-state Button that I have imported from Alpha sports to work. What annoys me is that that kind of button has worked for me in Approach several years. Since I stumble already on the first step maybe A5 is not for me. However I would like to be able to work with A5.

Thanks for your time and effort.

Jan

[Stan Mathews]

RE: New record in child table

Make the "Agare_Medlnr" field be width 4 (like Medlnr in the parent table) instead of 3 to solve the linking issue and your child records will link to the proper parent record.

[Stan Mathews]

RE: New record in child table

In the AlphaSports customer information form example of the multistate button, there are two variables set up in the form, variables, menu selection. In the form's oninit event, there is code to manipulate these variables before they can be used by the form.

Since you neglected this background preparation, your multistate button has no variable values to use.

I neglected to mention earlier, if you change your linking fields to character types, you will likely be better off in the long run. The general "rule" is that if you are not using a sequence of digits in a computation, store them as characters, not numbers.

[Jan Mark]

RE: New record in child table

Stan,

I knew linking fields have to have the same type and size, but had not checked this. Not being able to make these changes in A5 for some reason, I made them in Approach and made a new database again. It now works. Thank you.

Linking these fields should I use referential integrity when defining the link?

I have read a lot about autoincrement fields creating problems. Can I use autoincrement in the "medlnr" field? If not how do I make window showing what number to enter manually?

Jan

[Jan Mark]

RE: New record in child table

Stan,

I tried to adapt the variables in the form with the multistate button, but without success. Can you tell me how, since I do not seem to be able to follow the instructions "Creating and Using a Multi-state Button"?

Jan

[Tom Cone Jr]

RE: New record in child table

Jan,

The design of the AlphaSports sample application has been written up and is available for download. There's an entire chapter on the Customer Information form. I think the download link is on the Learning Center page of the AlphaSoftware website. If you don't see it there go to the Tech Support patches and updates page.

-- tom

[Stan Mathews]

RE: New record in child table

You've asked questions only you can answer.

Linking these fields should I use referential integrity when defining the link? - read what referential integrity does, in the documentation, then decide if that is what you want.

I have read a lot about autoincrement fields creating problems. Can I use autoincrement in the "medlnr" field? If not how do I make window showing what number to enter manually? - Auto increment is usually only a problem in data entry intensive, multi-user situations. If this is your set-up, write your own auto increment routine.

[Stan Mathews]

RE: New record in child table

Tom is correct, the "AlphaSports Explained" is on the Larrning Center page and is the best way to understand.