Search results

Hey all, I basically have a number of records, each record (row) has a field that can identify another record in the database. For example, Record ID 1 has a field that identifies Record ID 5, Record 5 might have an ID that identifes Record 12. Some records will not identify any other records...

Thanks Galaxiom. I'm a little unsure if this would work (I assume Join Table and Junction Table are the same thing?). If a vacancy was superseded more than twice, the 3rd record would hold the value of 2nd (as that's the one that's now being superseded), not the original so it still wouldn't...

Thanks for your input on this Galaxiom. I do see what you're saying but I don't think I can do it in the same table. The reason being that 2 or more vacancies could be superseded by just one vacancy (of a higher pay grade). What you say is interesting though. Would the field to hold the...

Thanks. This makes sense, however, if I wanted to run a query to show me the history of vacancies (i.e. a sequential list of vacancies that have superseded each other), what would I have to do? -NS

Thanks, I'll take a look!

I will try! Basically, a vacancy will either be filled or not. If it's filled than that fine. If it's not filled then one of 2 things might happen. One, it could be readvertised meaning it will have a new REF number, closing date etc etc. Second thin that may happen is the funding for that...

I think I see what you are saying. There should perhaps be an Advert table to which I can attached sepoerate vacancies (as One Advert, i.e. REF123, can have have many vacancies). However, I'm still struggling with the tracking superseded part of this. Any ideas? Thanks -NS

Thanks jDraw. I have attached a screenshot of my current tables. I have a few more lookup tables (for example, line manager) but have left these off for the sake of neatness. Any help would be great! Thanks for your time. -NS

Yes, this is all for one organisation. A vacancy will become available due to new funding or someone leaving. This will then be advertised and hopefully recruited to. I should point out that 1 or more vacancies can be advertised with the same reference number. For example, REF123 may be a...

Thanks jDraw, I'm using Access 2010. I currently have the following tables: tbl_Vacancies (VacID is the PK. This table contains the Vacancy Reference, title, grade, advert date, selection date etc) tbl_VacancyHist (VacHistID is the PK and VacID is the FK from. I also have a notes field so the...

Hey, still struggling a little with this. Can anyone offer any suggestions? thanks, -NS

Thanks Rod, I'll try this! -NS

Thanks rodmc, this does appear to be what I want! I'm a little confused by "the top 3 entries on this page". Please could you point me in the right direct? Many thanks, -NS

Hey all, Just thinking about attachments (Access 2010) and if they're a good idea in general. I'm aware that the max size of an Access DB is around 2GB and that if I'm attaching various word and PDF docs, it's going to grow quite fast. I'm also aware that Access 2010 compresses attachments...

Sorry for the bump - any help at all on this would be great! Many thanks, -NS

Thanks Never Hide, unfortunately that is not what I meant. When I talk about hiding options I mean actual items in the list, not the fields. For example, the items might be a list of all employees. If Joe Bloggs leaves the company, I want to tick a hide box next to his name in the employees...

Hey all, At the moment, when using a combo box to select options I normally use a query for the record source that filters out any options that have a "hide" or "ended" check box ticked. This is simply to stop users selecting options that are no longer applicable and also to stop the combobox...

Thanks jDraw, I'm not sure this is exactly what I need. I will try an explain better... I am basically logging and tracking vacancies. Sometimes, a vacany will be advertised but not filled and will be readvertised as another with different details. What I need is a way to link this new vacancy...

I didn't know this...good tip!

Thanks Bob, I'll take a look.