Report problem (query)
Posted: Thu Mar 18, 2010 9:24 am
Hi, im building a report that shows info about a product, like name, serial no, etc, only of those in stock, show the fields on a simple table like this:
Prod Id | Prod Name | Serial no | Entry date | Amount | Type of entry | Show(entry) | User(who made the entry) |
Problem: there are 2 types of entry, one though manual entry and other through request(like from supplier). I need that, if its a manual entry, it show manual entry on type col, and the link to that entry, and if its a request, shows request on type and the link to that resquest. Tables look like this
Product: id, Name, Serial No
Request: id, amount, entry date, product_id, user_id
Manual Entry: id, amount, entry date, product_id, user_id
User: id, nome, username, password
I couldnt find a solution cuz a product can be at the same time on both tables, and many products dont have a serial no, and besides the serial no, i cant see another way, i need help
Prod Id | Prod Name | Serial no | Entry date | Amount | Type of entry | Show(entry) | User(who made the entry) |
Problem: there are 2 types of entry, one though manual entry and other through request(like from supplier). I need that, if its a manual entry, it show manual entry on type col, and the link to that entry, and if its a request, shows request on type and the link to that resquest. Tables look like this
Product: id, Name, Serial No
Request: id, amount, entry date, product_id, user_id
Manual Entry: id, amount, entry date, product_id, user_id
User: id, nome, username, password
I couldnt find a solution cuz a product can be at the same time on both tables, and many products dont have a serial no, and besides the serial no, i cant see another way, i need help