Search results

These are good points, I appreciate your feedback. I didn't consider the city part of the equation because we currently only operate in one State (we're a pretty small business). That being said, I will definitely look into this, having a list of cities would help normalize the data and avoid...

Thanks for your reply. I do use the start date and end date for my product price table, but I never considered using it here, that is a great idea. I'm thinking I need multiple tables. Do you see any downfalls of having things separated as follows? tblProperty PropertyID (PK) PropertyAddress...

I track the management company right now - but an ownership table might be a good idea, haven't thought of that one. I'll talk to the boss.

Yes, I should save them all. You're right, one-to-many is a good way to go. So many changes from my "simple" database that we only wanted to track a few things.

It's amazing, but yes. I've been here less than 10 years and one property has changed names 3 times.

That's a great idea, I didn't think of that. Thank you.

I am doing some database updates and would appreciate guidance from others. We have a table that records basic details (id, name, address, city, etc..) about a location (tblProperties). Within this table we have a field called PropertyName - this field can represent an apartment complex name...

Thank you. mike60smart combo box example helped me immensely, I just couldn't visualize what needed to happen.

This is perfect, thank you so much. It seemed like it should be so simple but I don't use anything like this anywhere else in my entire database. I could not wrap my head around this for all the peanuts in the circus. I greatly appreciate your taking the time and help me with this.

I don't think I'm explaining this well at all, I apologize. We have a lot different tables with many related tables. Those tables house information on properties, machines, management companies, service calls, inventory, gross sales, vandalism, commission details, etc. When the owner is in a...

Hello jdraw, here's an example of how a new property gets added and notes we take. We received an email from a property that does not currently have vending and would like us to come out and see if we can assist them. We have a property name / address / phone / email / managers name. I created...

The naming is directly related to the other tables in the database; it's how the owner describes things so it's directly named based on how he wanted things. tblProperty - has a bunch of basic property information including address, city, state, county, tax rate, email, etc. tblPropertyType -...

Thanks June7. Would you have a combo box and then write the answer to a table that the user sees and can continue to pick items and have an "add" button for each attribute they select?

The attributes table consists of items we want to quickly query to be sure we are putting in products and have signage that meet demographics; i.e., apartments have rankings, A, B, C, D and managers tend to tell us the current building ranking, seniors and 55+ tend to like different candy and...

Hello Everyone, I have a database used in a vending machine business. If I'm told about a location's attributes I put the information in notes field associated with the property. Unfortunately this is not a very useful way of doing things. I cannot easily find data on the 250+ different...

I found the issue. I had to change from a LEFT JOIN to an INNER-JOIN Didn't Work: FROM qProductsSold_Candy LEFT JOIN tblVendPricesCandy ON qProductsSold_Candy.MachineID = tblVendPricesCandy.MachineID Fixed: FROM qProductsSold_Candy INNER JOIN tblVendPricesCandy ON...

Thanks jdraw. The unique identifier is the ProductInOutID. Here's the SQL of the query: SELECT qProductsSold_Candy.ProductInOutID, qProductsSold_Candy.MachineID, qProductsSold_Candy.ProductSold, qProductsSold_Candy.ProductExpired, qProductsSold_Candy.FillWeek, qProductsSold_Candy.ProductTypeID...

Hello Everyone, I'm struggling with duplicate items in a query and completely stumped as to why it's happening. I have walked away from this issue for a week and came back to it yesterday and today and I'm still as frustrated as last week. We have a vending business and track a lot of...

Thank you. I'm just learning how to use forms to filter queries and generate the reports I need. I will certainly look into it.

Thank you Markk, this worked perfect.