In Access 2000 I need to create a primary key out of elements from two different tables across several different fields. So the first question is how do I do this? The second question is where do I do this, i.e. is there a wizard of sorts that can walk me through this? I thought I'd checked everywhere and I just can't seem to find anything. If someone could let me know I'd appreciate it so much.
View RepliesOkay, can anyone help me with the following:-
I have to create a database on theatre booking system. So far, ive identified the following entities:
Customer(Customer ID, Title, Initials, Surname) Customer ID is PK
Bookings(-------)
Play(Playname, Playwright, Number Of Characters, Length(min)) Playname is PK
Actors(-------)
i do not know what to create as attributes for the bookings table, especially seeing as the attributes have to relate to customer and play. for the actors table i was thinking of putting in the following attributes:-
Actor ID, Name, Age, Playname, Role (Actor ID is PK)
but i was unsure if they worked, although i think they would, because playname from the play table would be a foreign key in the actors table. this is where i come into conflict with the bookings table, ie what could add to teh custoemr table as a primary key that would make a suitable foreign key in the bookings table, and what could be a suitable primary key in teh bookings table, and also a suitable foreign key in the play table? please help, its an urgent issue. thanks very much for your time.
Fergal
Hey guys, I have a simple design question I hope someone can help me with. I have little to no experience with Access, but I know enough to get around. Anyways, I'm working as an extern for a rock band. One of my assignments is to create a publicity contact database. I have all my forms and tables set up but I'm having some trouble creating my query. There are about 10 fields in the contact table. I want the user to be able to search any one of those 10 fields OR any combination of them. Is there a way to do this with only one query, where it willl prompt the user for only the fields they have selected to search?
View 2 Replies View RelatedHello.
So, basically I have an input form. I disabled pretty much all of the controls and instead of using the left and right arrow buttons I wanted to create my own ones to go to the next record. What happens is that the button pushes down, but doesn't unpush. And then if i push it again it pops back up.
This is what is in it, as far as code goes for my button:
DoCmd.GoToRecord , , acNewRec
... so, yah. It seems kind of idiotic, but i hope someone can tell me what's up because it's really annoying!
Thanks!
Okay. So, this is my set up.
I have a form that has various input fields that are connected to my main table. What I want to do is have my form allow the user to enter information, leaving some of it blank if they don't want it, and then press a button and it will open the query with the arguements given. The problem i'm having is... when i leave a field blank, it doesn't pull up anything, but if i fill everything out then it's fine. Right now my criteria on my query sections just link directly to the combo boxes that i have created on the input forms. I believe i just have to have additional criteria, telling it to ignore null or something like that... but i'm not sure how! Please aide?
thanks!
Hello,
When I open an already created form just linked to a table to input new information. At the bottom is says, for example, 1 of 30. How can I make it so that it just adds a new entry at the end of that 30, being 31? And then, perhaps sorting the table... after all the data has been entered. Your help would be much appreciated!!
Thanks!