|Published (Last):||21 November 2015|
|PDF File Size:||19.91 Mb|
|ePub File Size:||14.65 Mb|
|Price:||Free* [*Free Regsitration Required]|
I have the same question 0. Yes No Sorry this didn’t help.
So far I have figured out all the fields that I might need and laid them out on a form for the users to input the data. Good Day I am trying to help out a friend with a project at his attorney firm.
My questions are as follows: Sorry this didn’t help. Mz was thinking of perhaps a drop down list that the users could select with the amount of owners in it.
Tell us about your experience with our site. On you search form the logical choice for selecting one or more owners on which to query the data would be a multi-select list box. How would I implement this on the table side?
That would be very bad design and create a lot of headaches for you in querying the data. One issue I have so far is that one Property might have one owner or a group of two or three or multiple owners.
How could I create this on the form? You’ll ldf an example in the file MultiSelect. Is their perhaps a better way to do this since I don’t know how many contacts I am going to need? This site in other languages x. Right now they are working from multiple excel files and pdf files or manually looking things up on paper copies.
OwnerID PK The last table might well have other non-key columns representing attributes of a person’s ownership of a particular property. Depending on their choice it would open up the required number of fields for them to input the data.
As you could have a situation where the same person is an owner of more than one property, and each property can be owned by multiple people you have a many-to-many relationship type between properties and ms access multiple choice questions and answers pdf download, so you’d model this with three tables along these lines: The goal is to create a Database for the attorneys to search through that contains all relevant info regarding the purchase of a property.
Did this solve your problem?
Access Form Multiple Choices Setup – Microsoft Community
Thanks for any help! Ken Sheridan replied on May 24, RenegadeWolf asked on May 24, Don’t even think about creating multiple contact columns etc in the table. The idea is to make a form that the estate agents could dlwnload in that contains all the relevant data needed that could then later be used for reports and queries. February 12, Applies to: