Search results

Ah ok, so rather than linking an order to another order, I would link them both to 1 payment. Thanks for the reply, I will upload a copy of it tonight with some sample Data in it.

Hi, I made a post explaining a database, but I have now came to a conclusion on the database structure; If somebody could look and comment on my listed design it'd be great! And feel free to ask for info, I always miss things :banghead: Table Structure Customer Details (Person 1 & Person 2)...

Hi Gemma, Thanks for those ideas, I suppose your right, currently the "main customer" is always the women, so I could add a "sub customer" so to speak. Maybe I am underestimating the power of queries and reports. With this I'm going to go speak with them and get a definitive idea using iput...

Thanks for the speedy reply. I'm glad you could make some sense of my waffle! I'll start with the second part first, we do get repeat work actually! eternity rings, and a new thing is to get a ring with manmade diamonds, and for anniversary's, birthdays buying real diamonds to swap in at a...

Hello, first post in long time here, restarting a project i abandoned. Firstly, my access knowledge is limited, although i taught myself a lot last time, and eager to relearn. My database is for tracking orders for wedding rings, and currently is done using an Access DB. Now its over 7 years...

<---Your messsage :confused: <-- my head! Ok, basically all i done is added a button and given it the save form feature. So if thats the 'elevator door close button' is, then i obviously have been doing it wrong! lol. I'm working on database at the moment. i will upload a new copy later and...

from the local

Hello, I have added a save button to my form, and i was wandering what are the benefits of this? As it seems even if enter data and close the form without saving it seems to still appear? Have i set it up wrong?

Ahh brilliant, cheers!

I am looking into this now, and yes your understanding is correct. Thanks very much for the reply nigel. I have now been given more requests on the databases features.. so i shall be posting alot more! (eek!) ------------ After looking where is this relationship? Do i create it on the tables...

sorry if bumping isnt allowed, but i cant seem to figure out how to sort my problem out on my database. Anybody able to help?

Hello, I have Recently been plodding along with my database and im now hitting more problems! Wohoo!!! This first image is of the tables, setup perfectly how i want them. Now i want to portray this information in forms.. which i have done....... kind of. Red = Error im having, i want the...

Hello, If you havn't guessed my name is David! I'm an amateur Acesser?/Databaser Whatever its called! I'm working on 2 Databases, one of clients and chickens they breed, and one of clients, rings and their orders. & Hoping to release them here for people to use as a resource once i've picked...

Would there be another way of doing this? I'm interested as in my database i have office staff, setters, craftsmen, and reps, and having them in one long list is a bum.

BF3 Graphics may top COD... but COD is still massively popular after 6 releases, and i cant seem to find anybody who i know with Bf3

Ahh :), makes everything much clearer now.

Does it matter if each FE is the same? but 4 copies on each desktop? I assume your saying don't let people shortcut it from the network.

Sorry if double posting is against rules, just felt editing would make my previous messy post messier! After thinking, how does this setup sound CLIENT INFORMATION -->order history (subform) ---->Order tracking (subform of a subform) Client information id his first his sur her first her...

Well i did google it and its why i ended up here! lol, its very confusing, but i am still looking into it, however my relationships etc never worked! Also in theory it should be 1 trade per customer, only in rare cases would a person need to come back for another ring. If so they would be key'ed...

Well in that case i shall carry on with my current structure just having 20+ fields seem silly if there was a better way. As for repeated orders, these are custom made wedding/engagement rings, so fingers crossed they shouldn't be coming back for new ones unless they loose them! lol. If so they...