I guess I'm a novice now that I've shifted from Filemaker to Alpha 7. Does it really have to be so darned hard??
I don't know whether to give it up or not - you've all helped me before, and I purchased Alpha based on that experience.
I have a two table (for now) database with Parent table BORROWERS containing all of a bank's borrowers with key field BORROWER_NBR. The one-to-many child is NOTES table, where one borrower can have multiple notes. The notes table contains BALANCE, DATE, PAYMENT, ETC., the borrowers table contains BORROWER_NBR, NAME, SHORTNAME, ETC.
I just need to know if I can easily do this:
I want an interactive report or browse so I can look at it an choose certain borrowers. I want several fields to show based on the BORROWERS table. I want to include items from both tables, but I do NOT want to show every record in both tables. Every time I design a SET, I get all the records from both tables - that doesn't help. I want the following to show only line by line:
BORROWERS:BORROWER_NBR
BORROWERS:NAME
BORROWERS:SHORTNAME
NOTES:TOTAL (OR SUMMARY) NOTES (FOR EACH BORROWER_NBR)
NOTES:TOTAL (OR SUMMARY) BALANCE (FOR EACH BORROWER_NBR)
I also want a boolean checkbox for "SCOPE" at the BORROWERS level, which I can check to review that borrower or not.
I have built this successfully in two databases, Approach and Filemaker. I can't get anywhere near it in Alpha!!
Please help if you can. I'm at a choice point here again, and may just write off my purchase of Alpha. I'm not a whiner, really, but I shouldn't be spending hours and hours trying to get this thing done!
Thank you,
Fred
I don't know whether to give it up or not - you've all helped me before, and I purchased Alpha based on that experience.
I have a two table (for now) database with Parent table BORROWERS containing all of a bank's borrowers with key field BORROWER_NBR. The one-to-many child is NOTES table, where one borrower can have multiple notes. The notes table contains BALANCE, DATE, PAYMENT, ETC., the borrowers table contains BORROWER_NBR, NAME, SHORTNAME, ETC.
I just need to know if I can easily do this:
I want an interactive report or browse so I can look at it an choose certain borrowers. I want several fields to show based on the BORROWERS table. I want to include items from both tables, but I do NOT want to show every record in both tables. Every time I design a SET, I get all the records from both tables - that doesn't help. I want the following to show only line by line:
BORROWERS:BORROWER_NBR
BORROWERS:NAME
BORROWERS:SHORTNAME
NOTES:TOTAL (OR SUMMARY) NOTES (FOR EACH BORROWER_NBR)
NOTES:TOTAL (OR SUMMARY) BALANCE (FOR EACH BORROWER_NBR)
I also want a boolean checkbox for "SCOPE" at the BORROWERS level, which I can check to review that borrower or not.
I have built this successfully in two databases, Approach and Filemaker. I can't get anywhere near it in Alpha!!
Please help if you can. I'm at a choice point here again, and may just write off my purchase of Alpha. I'm not a whiner, really, but I shouldn't be spending hours and hours trying to get this thing done!
Thank you,
Fred
Comment