Okay, Im relatively new to Access and Im trying to create a database for Characters/People. Ive worked with an older version back in highschool- like as in what i see in a lot of vanilla examples; a Customer table with ID as key, Name, address, phone, ect,, a Product table with ID as its key but linked to Customer table by customer ID, ect. I could probably do something as simple as that. Now, for my needs, I want a database/tables containing Name, age, height, sex, description, and a couple other fields specifically related to the character. Also, i need a table for animal names, species, and age.
Ive figured out a fair amount of how to enter all of this multiple ways, but not one way that enables everything else like form building to work properly, let alone queries or reports. On top of that, i want another table containing character specific description info. id prefer to have a male and female version of that table so i dont have everything lumped together on one and from what ive seen, you SHOULD split info into multiple tables, thats the point.
Sorry for the long description, i know bits and pieces of what i need but not specific what to ask for help for. This is also why im posting here, since its about all aspects. Would some kind soul take a look and see if what ive got so far can become workable or possibly provide a brief working-example once looking at what i have, to get an idea of exactly what i want? Pleaseeeee lol im at this point right now :banghead:
Ive figured out a fair amount of how to enter all of this multiple ways, but not one way that enables everything else like form building to work properly, let alone queries or reports. On top of that, i want another table containing character specific description info. id prefer to have a male and female version of that table so i dont have everything lumped together on one and from what ive seen, you SHOULD split info into multiple tables, thats the point.
Sorry for the long description, i know bits and pieces of what i need but not specific what to ask for help for. This is also why im posting here, since its about all aspects. Would some kind soul take a look and see if what ive got so far can become workable or possibly provide a brief working-example once looking at what i have, to get an idea of exactly what i want? Pleaseeeee lol im at this point right now :banghead: