AdamHughes
New member
- Local time
- Today, 22:31
- Joined
- Feb 17, 2006
- Messages
- 8
Hi,
I am working on a database for an assignment for university. I am seeking some help for one of the forms I am creating. I have a properties table listing all the details of a property and a unique ID, I have a client table and a booking table etc.
I want to create a booking form, but I want to make it so that the individual placing the booking can enter all the required information in this form. I have added all the tables required (three named above) and I have began to tidy everything up (removing the booking ID as that is auto generated, removing all of the property table fields and replacing it with a combo box) but the problem I am having is dealing with the client.
The problem is that if they already exist, I want to be able to select them from a combo box, and it'll update all the fields on the form relating to the client details, however, if the client isn't already set up in the database then they'll need to be added to the system and so all the fields will need to be filled in and the client ID will have to have its auto number created. But I just cannot work out how to get around this.
Can you shine any light on what I should attempt?
I tried doing the same as I did for property - creating a combo box, but because the client ID is an auto number in the client table, it won't let me select any values from the drop down. If I could do that, then I think it would work a treat.
I cannot change the data type from auto number to something else in the client table as the bare set up of the database I received has to remain the same as part of the assessment. I figured if I could change that to a plain text field then I wouldn't be having this problem. But I wonder if I can resolve it otherwise..?
Thanks to anyone who tries to help!
I am working on a database for an assignment for university. I am seeking some help for one of the forms I am creating. I have a properties table listing all the details of a property and a unique ID, I have a client table and a booking table etc.
I want to create a booking form, but I want to make it so that the individual placing the booking can enter all the required information in this form. I have added all the tables required (three named above) and I have began to tidy everything up (removing the booking ID as that is auto generated, removing all of the property table fields and replacing it with a combo box) but the problem I am having is dealing with the client.
The problem is that if they already exist, I want to be able to select them from a combo box, and it'll update all the fields on the form relating to the client details, however, if the client isn't already set up in the database then they'll need to be added to the system and so all the fields will need to be filled in and the client ID will have to have its auto number created. But I just cannot work out how to get around this.
Can you shine any light on what I should attempt?
I tried doing the same as I did for property - creating a combo box, but because the client ID is an auto number in the client table, it won't let me select any values from the drop down. If I could do that, then I think it would work a treat.
I cannot change the data type from auto number to something else in the client table as the bare set up of the database I received has to remain the same as part of the assessment. I figured if I could change that to a plain text field then I wouldn't be having this problem. But I wonder if I can resolve it otherwise..?
Thanks to anyone who tries to help!