Report problem (query)

[barbafh]

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

 

[fenway]

You likely need to handle this in application code.