Search results

Firstly, not sure how you mean make the equipment relate to jobs? How do I do this? The reason my forms are Unbound is probably because I don't have a clue what I am doing ;) :)

So, I am getting there. For now, I have all the tables I need/want. I have designed some forms. The way this will work eventually, is the form titled 'Opening' will be what you see, and you click on what you want to do... If you look at the 'project' Form, this is my main part where I...

Hi Ned, Well, you may have on job 1: 1 x 72 Way 2 x 48 Way 1 x 36 Way and on job 2 maybe two boxes in total, as its smaller etc. Essentially, the information that needs to to 'tie' in with the job is how many (and which) fuses boxes are on the job, what power supply they come from, and...

Hi Ned, I think I have made the changes you recommended...? So whats next? Cheers Neil

Thanks for that. Have had a look over the last couple of days, but can't seem to find any documented info, your your knowledge is in my hands :)

Yes. 0 is an option for a spare or empty Fuse 'way'. The data that goes to the output is the data that is entered in the 'way'. So, in TBL_Hookup we have entered a Hookup called Red 1, for example. Obviously, firstly, we need to tell the system which fuse box we have, how many of each etc...

Hi Ned, Each fuse box is limited two circuits of a Hookup....although those circuits could be in Hookup Red 1 and Green 50 - and any colours/numbers between. But thats easy, just referencing and typing it in :) The Hookup table does already have 6 outputs. It has obviously the name for the...

Oh, an Output (also referred to a circuit) is one of the six little wires in the Hookup, if you get me?

Hi Ned, Thanks for all this :) The relationships I broke myself! I managed to create them 'playing' and can't seem to get rid of them... So, the way it works is this: A Hookup is a cable, it has 6 smaller cables inside it. Each Hookup has a colour and a label for ID. Colour representing the...

Thanks for that, Ned. I feel I have the right tables in place, and have attached the db. So I am wondering whats next....? Cheers N

Hi Guys, Many thanks for your replies, in particular to NedKelly :) So, I have created the tables, and have uploaded them. I am guessing that, for this to appear on the table, each of the fuse boxes will have a unique ID? So, "36WFB1" for a first 36 way fuse box and then "36WFB2" for the...

Hi Guys, I am currently working non a new database, which is designed around electrical fuse boxes.... I must admit, I am very much a beginner at this, so please go easy on me :) Currently, we have a few different fuse boxes, they are 36, 48, 72 and 96 way. What I plan to do eventually, is...