Search results for query: *

Hi dhookom, Thanx again for your replies. No values should be added into the members and assets tables (maybe just a number in a field called "Asset number" or "Member number". This is just for creating corresponding records to the number of the family members - and their assets. The family it...

Hi there! This forum has helped me out before, so I hope you guys can help me out with this? I have one master table with two linked tables. Each time a new record is added to the master table - I want a number of new records to be added to the sub tables. 1. Master table = "Family" (general...

With your help, I managed to set it all up. The only thing I miss now, is to merge it all into one "table" (query - maybe?) so I can e-mail the families all the fields and get them to fill it in and return it to me. Any suggestions? As I got three tables? :)

Hi. I think i am able to make this work now. I did what you said - and added two buttons on the main form, named "Family members" and "Family assets" - opening, and filtering the members and the assets for the family. Next I want to merge this into one scheme - so that I can e-mail this scheme...

Hi again. Thank you. I have tried your solution. What kind of relationships do I have to set up? I tried this from the beginning - but could not enter any data in main table ("Famliy"). Am I doing anything wrong? I set it up with foreign keys in the two sub-tables, forcing cascade update.

Yes. I know how to set up forms and subforms. But I am not sure about the relationship part. If I just make one table with all the information in it, and then split it into subforms - it will be an overwhelming list of fields and information. And in this table I would have to enter: Family...

Hi You, Thanx for a fast reply. I am a bit of a novice on this. Could you explain it more in detail - step by step - for me? Thank you in advance for your help

Hi there. Hope you can help. What I want to achieve - is setting up a databases with two (maybe more) sub-tables related to a main table/form, in the work with a televison casting. The end result I want would be like this: Main table: Family: Johnsons Sub table: members: Family...