Search results

Regarding table and form-level validation. Given that all user interaction with the DB should be through forms, is there any need to have table or form-level validation through these objects properties when it can just simply be done in VBA on event? Is this just a case of preference? If so, I...

Now should I be as pendantic about storing phone, email addresses etc :rolleyes:

Thanks jdraw. I have actually seen those videos before and have watched a lot of the DB/Access stuff on youtube. I will probably watch them again though just to recap.

I think my suggested schema is pretty much what is described in the schema in the link that jdraw posted above.

Forgive me if I am being a little slow here, still trying to get my head around things. The idea behind my addressing schema would be so that the addresses are all held in a single table (as you suggest above) and that the addresses are related as a customer delivery/billing (lets call this...

Excellent link. Thanks.

Thank you. I think I follow. The data in a current invoice can be derived via a domain function (DLookup) or it can have a one-to-many relationship to the current price. And, if the second option is used, the price will retain as, when the price is updated, the field holding the price will...

I should probably correct that - the derived data is not what would cause the problem with the price history, the overwriting of the price would. There should be a table holding the prices (active and inactive) for a certain product and a form would be used for the user to change the price, the...

Thank you very much for your input. It's kinda laborious trying to understand best-practice for a new technology and a lot of the Access DBs I have come across often seem to me to be too simplified for my liking and dont allow proper data-validation. I think the main problem I have with the...

Sorry about not being able to post pics - my post count is not high enough yet. I hope I havent bothered the mods.

So would this schema be OK for the table layout I mentioned in the original post? CountryID-Region and CountryID-City are both unique composite indexes. i46. tinypic. com/2czx7b6.jp g

Hi, Thanks for the response. I dont want to spend a terrific amount of time on the data. The database is actually for one of my businesses (an Ebay-type business) but I am generally just trying to work out what the best sort of schema to use for this type of system. I am a bit of a...

Hi folks, My first post here :) I am currently in the process of building my first serious DB (generic customer orders). I am beginning by building the tables for storing customer addresses. My professional background is as a data/database/quality management analyst in Finance and I am...