Search results

sorry about that - it's a bad habit....

I already have a relationship line drawn between them - is that the same thing?

What do you mean by 'join them appropriately'? I already have them joined by a relationship - is that the same thing?

and, last dumb question (for now).... my T2 now has a number in the staff name field. Is there a way to view the data that shows the name rather than the number?

do i need to create a query to be the record source or does that happen automatically?

Thanks for that. Let's see if i've understood you correctly. i create a form create a drop down set the source as my staff table and limit the data to this list my staff table has auto number as its primary key I don't quite understand T2. Is this the table that I'm trying to populate? I...

I wan't to limit entries in a field to those that appear in another table. e.g. to only allow people's names that appear in a table of staff members. Names will be added to the table from time to time. is this possible or is there an alternative? Should I use a form instead?

Got that CJ - thanks. If you have one table, one form, how can you have an input screen for entering lots of data into lots of tables? Do you create another form which contains all the individual ones?

This is all great stuff - thanks everyone. One thing I'm still not clear on - at what point do you start entering sample data? I did it after I had set up the tables and relationships but when I tried to use lookup fields I got into trouble. From what I can see of the advice given, it's best...

wow - I'm trying to get my head round that! When I saw the junction table with only numbers in it I freaked....

Thanks for the replies everyone. The database is an appointments database for scheduling appointments between therapists and patients. There are different types of therapists, sometimes more than one in a single appointment with a patient. I will need to print out a weekly schedule of...

Can anyone recommend a guide to building an access database from scratch? I'm looking for something that outlines a general, logical approach to what sequence to do things in, from pencil and paper to final formatting and splitting etc. I'm not too worried about detail, just the sequence -...

So in general terms, I have to introduce forms earlier on in my intended sequence to be able to safely select data from a list? Do you think I'm trying to enter sample data too early as well?

I've been reading up on junction tables but i can't work out how they replace lookup tables? For instance, I can't see how they would display a list to pick from.

thanks for that!

Thanks - I'll research junction tables. Is this a common question/problem for newbies? Is my general approach wrong? I had intended to build tables, add relationships, add some example data in datasheet view then go on to build forms and queries. Is that a sensible sequence?

Thanks for that. What alternatives are there?

I'm building my first database. I've created 4 tables and joined them with relationships. I have a table of therapists and another table listing the type of disciplines they might have (nurse, physio, OT etc). I think I have to add some kind of lookup list to the disciplineID field in the...

Please excuse the basic nature of these questions. I've tried to google them and had no luck. I understand that when you set an ID field as a primary key e.g. EmployeeID, it should be data type of autonumber. When that field appears in another table and you create a relationship with it, should...

yes, those are showing in the bar