Hi all,
I do apologise if this has been covered in a previous thread somewhere. I am a relatively new user to access. I have a database that has nearly everything I want and need and they even all work....well nearly all work
I work for a real estate agent in their new home sales department. I put together house and land packages while also looking after a display. I can easily set up a form in my database called 'house and land packages' (i know what you are thinking. nice and original) to accept this info. What I want to be able to is create a lookup or a search in my 'contact details' form to have the following so that when I get a client inquiry I can easily find the package rather then scroll through several dozen packages.
Suburb/Town (search field)
Package (THIS IS WHERE I WANT THE LOOKUP/SEARCH TO BE)
Referred (this is just a drop down list that works fine)
Date (this is just a popup calendar that works fine as well)
The search parameter will always be a suburb/town to narrow down from several suburb/town as each has several land estates and then several house and land packages. The packages are made up in a seperate form that work fine now after finding a few misplaced characters and works great. Packages would read House_Suburb/Town_Estate_Cost
The idea is then to create a monthly report based on package inquiries, suburb by suburb etc. I haven't got to the report part yet so I don't know if I will get stuck or not. One thing at a time
I have googled a number of different things but I may not be using the correct phrasing. I may be using Excel terms instead of Access terms which I read somewhere aren't interchangeable. I think my table is set up right and the form is how i want it to look. It is just the functionality not so much.
I have tried to give as much info as i can so if more info is needed I can try and supply it correctly. I attach a copy of screen shots that may help. Any help, even if it a video link or link to a relevant thread would be appreciated.
Cheers,
Jason
I do apologise if this has been covered in a previous thread somewhere. I am a relatively new user to access. I have a database that has nearly everything I want and need and they even all work....well nearly all work
I work for a real estate agent in their new home sales department. I put together house and land packages while also looking after a display. I can easily set up a form in my database called 'house and land packages' (i know what you are thinking. nice and original) to accept this info. What I want to be able to is create a lookup or a search in my 'contact details' form to have the following so that when I get a client inquiry I can easily find the package rather then scroll through several dozen packages.
Suburb/Town (search field)
Package (THIS IS WHERE I WANT THE LOOKUP/SEARCH TO BE)
Referred (this is just a drop down list that works fine)
Date (this is just a popup calendar that works fine as well)
The search parameter will always be a suburb/town to narrow down from several suburb/town as each has several land estates and then several house and land packages. The packages are made up in a seperate form that work fine now after finding a few misplaced characters and works great. Packages would read House_Suburb/Town_Estate_Cost
The idea is then to create a monthly report based on package inquiries, suburb by suburb etc. I haven't got to the report part yet so I don't know if I will get stuck or not. One thing at a time
I have googled a number of different things but I may not be using the correct phrasing. I may be using Excel terms instead of Access terms which I read somewhere aren't interchangeable. I think my table is set up right and the form is how i want it to look. It is just the functionality not so much.
I have tried to give as much info as i can so if more info is needed I can try and supply it correctly. I attach a copy of screen shots that may help. Any help, even if it a video link or link to a relevant thread would be appreciated.
Cheers,
Jason
