Re: [sqlite] Ultimate noob question: What do I do to reference another table?

LMcLain wrote: > Thanks for the replay Igor! > > I would heartily agree about getting a textbook. Do you have one that you > could recommend? I like "The definitive Guide to SQLite" by Michael Owens, it is excellent, except the index which sucks. It is a very good read and covers a lot of the

Re: [sqlite] Ultimate noob question: What do I do to reference another table?

Thanks for the replay Igor! I would heartily agree about getting a textbook. Do you have one that you could recommend? Thanks again, Lee Igor Tandetnik wrote: > > "LMcLain" <[EMAIL PROTECTED]> wrote in > message news:[EMAIL PROTECTED] >> Yes, this is quite the noob question: I want to

Re: [sqlite] Ultimate noob question: What do I do to reference another table?

"LMcLain" <[EMAIL PROTECTED]> wrote in message news:[EMAIL PROTECTED] > Yes, this is quite the noob question: I want to have one fields > reference another table, how do I do that? > Here's what I am trying to do. I have a bunch of fields(or columns) > Item, UPC, Manufacturer, MSRP for

Re: [sqlite] Ultimate noob question: What do I do to reference another table?

you need several tables, then you can refernce them thru a view to show what is related to what. --- On Fri, 7/18/08, LMcLain <[EMAIL PROTECTED]> wrote: From: LMcLain <[EMAIL PROTECTED]> Subject: [sqlite] Ultimate noob question: What do I do to reference another table? To:

[sqlite] Ultimate noob question: What do I do to reference another table?

Hi everyone, Yes, this is quite the noob question: I want to have one fields reference another table, how do I do that? Here's what I am trying to do. I have a bunch of fields(or columns) Item, UPC, Manufacturer, MSRP for example. I want to be able to choose the Manufacturer from a