Search results

Hi there, I have learned how to make a combo box filter data for the next combo box but I have now added a link table to create a many to many relationship (in this case it is contacts to store chains) so a particular contact can serve more than one store. I know why the filtering has stopped...

Our company manufactures Trailers/Machines. Trailers/Machines can be of different types.(grain trailer, manure spreader...) Tailers/Machines have different models (mainly by carrying capacity) Our company has a number of Dealers. A Customer orders/buys one or more Trailers/Machines from a Dealer...

Well in most cases an order can identify a trailer/machine, however from time to time we build trailers for our own stock or as a prototype and so would not have an order number in these instances. It is the trailer Production Number that we use to identify the machines, much like a VIN number...

Well the dealer places an order with us for their customer (this can just as easily be a stock order for the dealer to sell as and when required or for a hire fleet during the harvest season) and comes in as an itemised list with all the requested options, quantities, etc. The dealer has no...

The dealers are different agricultural stores across the country who sell our machines to farmers. They also carry out repairs under warranty on our behalf which we reimburse them for

Would it simplify things a bit if the axles are a bought in component from a supplier? I don't need to break these down into their individual parts but the axle as a whole has a serial code which I want to record so it can be traced to a particular machine. In short, does this still mean...

So by having the order linked to the BuildSheet doesn't mean Access can link it back to the dealer then? I will check what I have done when at work tomorrow but I must be misunderstanding the way I need to link the tables.

You have just about hit the nail on the head there so closer than you think! We receive orders from the dealerships that sell our machines around the country and occasionally for export. The order will naturally have an order number for the different machines they want (one, multiple or...

Ok here it is....albeit very basic The form is called frm_BuildSheet What I am trying to achieve is a form that allows you to build up the specification of a trailer. My first attempt I used up all the indexes because I had relationships linked to tables when all I really needed were lookups...

Hi there, thank you both for your help on this. When you say joined, do you mean by a relationship specifically like a 1-1 or 1-many or just a plain and simple joining line? Form record source is tbl_BuildSheet (I think this is wrong also as I want the selected data to go here) Row source...

Hi all, I have a form which has a combo box to display a list of dealers which worked fine until I added a field from a different table. Now when I try and select from the combo box list it says join key is not in recordset. Can anyone please explain what this means? Thanks : )

Hi Ryker, here is the db. So far when a dealer is selected, 00 appears in the text box but not the year prefix. I also need the serial number and the production code to run concurrently with each other each time a record is created but the serial number does not appear.

Ok well I've got so far but when it comes to typing the expression it tells me it can't find YearPrefix

Hi Ryker, do I just need to type this into the text box I want it to appear in then? Thanks again for your help

Hi all, I'd like to know how to return a prefix based on year to a text box in a form. Each trailer we build will have this code on it, much like a vin plate on a car and the prefix will change when a new year begins and the numbering will start again from the beginning. For example the year...

Could you explain how to go about making a query to achieve this please?

May I ask what else you did to get the combo box control source list to appear? I tried to do it myself by changing the relationships as you have but the list still does not appear for me to select the field to be populated.

Ok I see what you have done! So does this mean if I want a combo box to just look up data from other tables, a relationship has to be in place between them as this was partly the issue I had before when I had too many relationships causing the indexes to max out? Thank you so much for your...

No there will be other fields I will want to pull through but from different lookup tables. I was hoping that once I figured out how to get the first combo box up and running the way I need it to then the rest should follow suit? For example, the dealer will place an order for a particular...

Yup I have attached it here hopefully.