- My Forums
- Tiger Rant
- LSU Recruiting
- SEC Rant
- Saints Talk
- Pelicans Talk
- More Sports Board
- Fantasy Sports
- Golf Board
- Soccer Board
- O-T Lounge
- Tech Board
- Home/Garden Board
- Outdoor Board
- Health/Fitness Board
- Movie/TV Board
- Book Board
- Music Board
- Political Talk
- Money Talk
- Fark Board
- Gaming Board
- Travel Board
- Food/Drink Board
- Ticket Exchange
- TD Help Board
Customize My Forums- View All Forums
- Show Left Links
- Topic Sort Options
- Trending Topics
- Recent Topics
- Active Topics
Started By
Message
re: Any Microsoft Access Experts?
Posted on 1/17/14 at 1:47 pm to TheOcean
Posted on 1/17/14 at 1:47 pm to TheOcean
quote:
TheOcean
Your main takeaway from this thread should be to never model your data such that you have to create a new table in order to add a type of data you already have. If you have a bunch of teams and want to add one, you should only have to insert a record, not create a new table.
Posted on 1/17/14 at 1:48 pm to Tortious
I knew the brews would work
I'm going to spend a couple of days creating the db you guys suggested. I know exactly what you're talking about. I'll just send it when I think it's done.
I'll eta this with the junk email after I make one.
eta: databasedesignjunk@yahoo.com. If you could send the sample just as a reference, I would appreciate it.
I'm going to spend a couple of days creating the db you guys suggested. I know exactly what you're talking about. I'll just send it when I think it's done.
I'll eta this with the junk email after I make one.
eta: databasedesignjunk@yahoo.com. If you could send the sample just as a reference, I would appreciate it.
This post was edited on 1/17/14 at 1:55 pm
Posted on 1/17/14 at 1:49 pm to Korkstand
quote:
Your main takeaway from this thread should be to never model your data such that you have to create a new table in order to add a type of data you already have. If you have a bunch of teams and want to add one, you should only have to insert a record, not create a new table.
Definitely. Although this is likely the last db I ever design.
Posted on 1/17/14 at 1:50 pm to TheOcean
quote:
I knew the brews would work
Awesome. Glad you got some help on this. It's refreshing when the OT is good for more than bullshite.
Posted on 1/17/14 at 1:53 pm to mikelbr
I'm doing a million things outside of trying to learn this stuff, so I really appreciate the help. If I had the time I would have learned this stuff from scratch, but I just don't have the time.
Posted on 1/17/14 at 1:56 pm to TheOcean
Some good advice here....and some bad. I think I'm following what your saying by "transferring" the info. If I'm correct take a look at sub-forms within a form. For instance if you have a form displaying all the generic info of the person, you can place a sub form on the same form that could "add and/or edit data in another table. The connecting link is to give a field in the sub form a default value of the same type of field in the main form. This way you won't have to re-enter the same data ie name, ID and all other data you want in both tables.
Posted on 1/17/14 at 2:01 pm to possumgritz
I'm ditching the transferring idea and I'm just going to do what tortious/mikel suggested. So the user will create the competition data and then the competition data will have a drop down boxed linked inside of the main form.
Posted on 1/17/14 at 7:06 pm to TheOcean
quote:
databasedesignjunk@yahoo.com
Sample sent brah
Popular
Back to top
Follow TigerDroppings for LSU Football News