Jump to content

Archived

This topic is now archived and is closed to further replies.

Nostal

A little help?

Recommended Posts

I've been creating a database for a series of comic books that a group of friends and I are publishing and within our database we want all entries to include which series it came from.

At first I was going to create 3 fields in each table called series1, series2, and series3 and then just use a WHERE statement in my query, however, there must be an easier way to do this and with only a single field. Or am I wrong?

Please let me know as soon as possible. Thank you.

Share this post


Link to post
Share on other sites
[quote]Please let me know as soon as possible[/quote]

er, this isn't a help desk, it's free advice :)

If you had a field named series, you could put a single number in it, or since (I guess) the [i]identical[/i] thing can't be in more than one series just use a field named series and put series1, or series 2, or series 3 in it.  More than that, I can't tell as your database structure isn't known.

Share this post


Link to post
Share on other sites

×

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.