Recent content by PhilD

:) :) :) :) :) :) Squid and everyone else.. you're all genius, take a bow.. It actually works EXACTLY like i want it. In the end thanks to all the advice i stuck to one table and two forms. then linked them together. Feel a bit of a dummy now as it was sooooo simle.. Thankyou VERY...

Hi squid.. lol lol, pan fried brains fried in beer! Lets totally ignore customers and its terms and use SHOP and OWNER. lets start again. I want a pop up form to appear on the main form which brings up the owners details. (Contact name, address and tel number.) Now i'm not sure whether...

Hi Neil Happy New Year.... I'll do my best to explain this as I'm confusing everyon, I'm the dummy here by not explaining it right. I'm based in uk so everthing regarding terms etc are uk terms such as merchants. The database is for keeping track of merchants (Ie retailers) who take credit...

Help any one got any ideas please.

Right I have attached the file so everyone can see what i mean.. I am not bothered if i only need 2 tables or if one will do. More important is the Merchants contact details appearing in another form from a command button on the main form. I'm thinking that one table might be best where all...

i think i'm condusing people with my table names !! the Tbl_Customers holds the merchant names and address, so lets rename it Tbl_merchants. I want Tbl_main to be the main form which will hold infomation about the merchant such as trading name, comapny number, turnover, comments. On this form...

Thanks for all your help so far I'm not very good at explaining this I am !! Sorry Neileg, Thats Exactly what I wanted, fantastic Each record change in the main for brings up a different customer. I've a better understanding I think, I need the primary key in Tbl_main (MerchantId) to be...

Neileg, Pat thanks for that, guess i better try to expain this better. The result I am after is on the frm_main I want a command button which pops up another frm_customers where all the customer details are. (name, address, town) I also want to make it so you can't scroll through the various...

ohh, forgot to add this.. Tbl_main merchant ID (primary key) merchant name company nos account opened Tbl_customer customer id (primary Key) customer name address town post code

Thanks for the reply. So far i've got In Tbl_main My primary key is customer number which is an autonumber. In Tbl_Customers My primary key is customer id.(autonumber) No corresponding keys in either table. (will I have to create another key in one of the tables?) I'm at a loss really...

tried this it still doesnt link the two sets of data together from the tables.. I've a customer Id refernce from tbl_customer and a Merchant Id from tbl_main. i've tried to crete a relationship between both tables on a one to one. data sill doesnt move when i move between the records, the...

Hi Hopefully someone can help me here. been struggling with this for a while. Here's the brief!! I have a access 2000Db, In it are are 2 tables, Tbl_Main & Tbl_Customer. and two forms frm_main & frm_customers based on the tables. I have created a form called Form_main On this i have...