got this table that I need to put into a db so that when 2 values are selected it gives you the result i.e colum 120 and row 1.5 would give you 2, im pretty new to this so any help would be great do i need 2 tables im not sure?
dandixon
0
Junior Poster in Training
Recommended Answers
Jump to PostNo, make RowNum, ColNum primary key, CellValue a non-key column. No rule that says a key column has to be an integer, so you could have your RowNum be float or real. Or just have a non-significant key column, with RowNum, ColNum be an alternate unique key. Query as "select …
All 3 Replies
BitBlt
452
Practically a Master Poster
Featured Poster
dandixon
0
Junior Poster in Training
BitBlt
452
Practically a Master Poster
Featured Poster
Be a part of the DaniWeb community
We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.