Although I�ve been using Alpha products for years, I think I came across something that may be a bug. I really hate using that word because most of the time we learn it�s actually user error, and of course I am no exception to that user error rule. However, I came across something this morning that I cannot figure out. Maybe I am doing something wrong or maybe there really is a bug? That�s why I need some help.
I have a set design that is driving me crazy. It is a small one-to-many app that functions like a checkbook. I have no problem with the functionality of the design, but I have a concern reference the display order of the child records.
Even though I used Form properties to order the CHILD records by Trans_Date, they still display in Rec_No() order. I went to the custom browse and ordered the child records by DTOC(Trans_Date} and even that didn�t help. No matter what I did, Alpha insisted upon initially displaying the child records from tblTransaction in Rec_No() order.
I thought this was bizarre and found it quite frustrating. So after several failed attempts to correct what I thought was a very simple problem, I decided to try something I haven�t done in awhile. I went into �SET DESIGN�, I selected �Edit Link� for tblTransactions, and then I set the display order of the child records to
DTOC(DATE_TRANS)
Low and behold, that did the trick. Now my child table transaction records were properly sorted and the set opened showing the first record in the table by date order. That was exactly what I wanted, but this was when I discovered something very strange and the reason for this post.
Please note: The parent � child tables are linked One-to-Many by the [Acct_No] field.
After editing the set as described above, when entering new records into the child table, the Acct_No is no longer automatically entered into the child table. As you can imagine this totally ruined any attempt at data entry via the Set, something I�ve never seen before.
Can another Alpha veteran please try this and see if they get the same results. This happens with both my custom form/ custom browse and it also happens when I tried it with the basic default form for the set. I am using the latest download posted last night.
Am I missing something? Am I doing something wrong? Or is this really a bug?
Thanks,
Robert
I have a set design that is driving me crazy. It is a small one-to-many app that functions like a checkbook. I have no problem with the functionality of the design, but I have a concern reference the display order of the child records.
Even though I used Form properties to order the CHILD records by Trans_Date, they still display in Rec_No() order. I went to the custom browse and ordered the child records by DTOC(Trans_Date} and even that didn�t help. No matter what I did, Alpha insisted upon initially displaying the child records from tblTransaction in Rec_No() order.
I thought this was bizarre and found it quite frustrating. So after several failed attempts to correct what I thought was a very simple problem, I decided to try something I haven�t done in awhile. I went into �SET DESIGN�, I selected �Edit Link� for tblTransactions, and then I set the display order of the child records to
DTOC(DATE_TRANS)
Low and behold, that did the trick. Now my child table transaction records were properly sorted and the set opened showing the first record in the table by date order. That was exactly what I wanted, but this was when I discovered something very strange and the reason for this post.
Please note: The parent � child tables are linked One-to-Many by the [Acct_No] field.
After editing the set as described above, when entering new records into the child table, the Acct_No is no longer automatically entered into the child table. As you can imagine this totally ruined any attempt at data entry via the Set, something I�ve never seen before.
Can another Alpha veteran please try this and see if they get the same results. This happens with both my custom form/ custom browse and it also happens when I tried it with the basic default form for the set. I am using the latest download posted last night.
Am I missing something? Am I doing something wrong? Or is this really a bug?
Thanks,
Robert
Comment