Good day,
I am having trouble with my dbase.
i have 2 tables first is the maintenance table while the other is transactional table.
on my maintenance table i have field(id, plan, material,type,percentage)
while on the transaction table (id,material,description)
here is my problem.
on the maintenance table let say
id plan material type percentage
1 1010 sample in transit 100
2 1011 example haulage 50
3 1012 mysample production 100
based on the data above i want to select type and join it on the transactional table.
let say...
id material description INTRANSIT HAULAGE PRODUCTION
1 sample sample description 100 0 0
2 example example desc 0 50 0
3 mysample my sample desc 0 0 100
here is my problem.
on the maintenance table let say
id plan material type percentage
1 1010 sample in transit 100
2 1011 example haulage 50
3 1012 mysample production 100
id material description INTRANSIT HAULAGE PRODUCTION
1 sample sample description 100 0 0
2 example example desc 0 50 0
3 mysample my sample desc 0 0 100
based on the data above i want to select type and join it on the transactional table.
id material description INTRANSIT HAULAGE PRODUCTION
1 sample sample description 100 0 0
2 example example desc 0 50 0
3 mysample my sample desc 0 0 100
can someone guide me with this.. thanks