Search results

Hi Doc, That's a very interesting idea. It's certainly possible to do this in FileMaker Pro (my background) with good effect. I'll investigate how to do this and see what the general opinion of the online community is of doing it this way. Thanks for the suggestion. Cheers, - Andy

Hi Paul, The reason that I didn't want to just take a copy of the Invoice database and build on that is because there are bound to be changes to that, even after deployment. If I was to work it this way then I'd need to update both the live 'Invoice only' database plus my 'Invoices + Stock'...

Hi All, I'm just starting out on a project that will evolve to include our invoice system, bank system, stock control and purchasing. Initially I plan to build the invoice part and when this is up and running work separately on the stock control. My question: If I build and deploy the invoice...

Hi dk, First apologies for my late night post yesterday. I hadn't spotted that it wasn't you who included the quote... from you! Thanks very much for the demo. This, together with your explanation, made it clear what I need to do. I've now changed my db accordingly and it works! :D In...

Hi dk, Umm.... The line that you quoted doesn't come from either of my posts. You must be thinking of somebody else! I do indeed want to filter an address ComboBox based on a value but that value is a field within the current record in the Customer Table and not a value selected from a...

Hi dk, Thanks for the lightning fast reply. I'm just leaving work here in the UK and hoped for an answer by morning, not before I put my coat on! I guess that you have misunderstood. I don't want to do cascading ComboBoxes, just a single ComboBox that only shows the addresses that relate to...

Hi all, Apologies for the total Newbie question. This is my very first Access Database and I've run into problems right from the off! I have 2 tables: Customer & Address Amongst other things the tables contain the following fields: Customer: CustomerID, ShippingAddressIDRef...

Hi all, Sorry for such a Newbie question but.... I'm trying to find the equivalent of Filemaker's Lookup function within Access. To quote the Filemaker help page: "A lookup copies data from another table into a field in the current table. After data is copied, it becomes part of the current...